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.