Skip to content

Mikey Bronowski - Blog

Select stars from the space

  • Blog
  • Mikey
  • Contact
  • Home
  • dynamic array formulas

dynamic array formulas

2020-09-29 by Magda 0 comments on "XLOOKUP function and dynamic array formulas – Excel 365."

XLOOKUP function and dynamic array formulas – Excel 365.

Post thumbnail

I always used VLOOKUP formula, I could do it even with my eyes closed, but now when I have Excel 365 I can use XLOOKUP, which is similar but not the same. When I have learned this new functionality I found out that I also have an option to use dynamic array formulas in a…

Read More XLOOKUP function and dynamic array formulas – Excel 365.

Primary Sidebar

Recent Posts

  • How to import/export data between SQL Server and Excel using PowerShell?
  • How to protect Excel using PowerShell?
  • T-SQL Tuesday #135: The outstanding tools of the trade that make your job awesome – write-up

Archives

  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • February 2020
  • December 2019
  • September 2019

Tags

add-ins azure CHART chocolatey community ctrld datascotland dbatools delete duplicate dynamic array formulas DYNAMICFORMULAS excel Excel365 github graphs graphviz import importexcel instalation learning Microsoft Office msx outlook pdf powerbi powerpivot power query powershell pskoans scripts series shortcut # speaking sql sqlfamily sqlserver ssms tips&tricks tools Tooltip tsql2sday tsx windows XLOOKUP

Enter your email address to subscribe to this blog.

Copyright © 2021 Mikey Bronowski - Blog. Powered by WordPress and Themelia.