Рет қаралды 16,709
In this tutorial I have discussed the following features of the new XLOOKUP function with practical examples:
0:25 Return Multiple Values With Horizontal Spill
0:23 Return Multiple Values With Vertical Spill
3:27 Return Multiple Values from Non-Contiguous Ranges
4:34 Dynamic Ranges With Xlookup Function
Download the Work FIle: tinyurl.com/fheanz34
#Excel #Xlookupforbeginners #ExcelXlookup #Vlookup