XLOOKUP Advanced Function with Examples
HTML-код
- Опубликовано: 30 май 2021
- 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
A very visually pleasing walkthrough. Thank you for this information.
Thank you! Please share and follow my channel for more videos! Thanks again 🙏
Interesting presentation, Than you!
Wonderful work here! Thank you!
Very good, thanks!
Sir could pl solve my problem, in the last example-Dynamic ranges,if we calculate for each salesperson,what will be forumale.thankyu
Which version of Excel are you using?
Sir, I had a question about dynamic XLOOKUP. Could you please help me? I want to fetch total sales region-wise here. Is this possible?
ขอบคุณครับผม. (Thanks )
Welcome ❤️
Can u give hw to do total value if choosen East region Only region Sales is needed in xlookup
nice. always put pratised file in the description...
Hi! Thanks for the content
When returning mutiplecolumns using xlookup the fill handle is not working ...Can you suggest some ways to resolve this ..I have a long list I dont want to drag the functions
Hi, what excel version do you use? And could you please elaborate more about your query so that I could give you a solution.
@@SdMotion Thanks for the reply...I am using Excel 365 ...I tried xlookup to return multiple columns now I want to drag this formula to lets say my 2k rows the fill handle of the xlookup cell is not working
1. Type the XLOOKUP formula you want to use in the first cell where you want it to appear.
2. Make sure the cell reference in the formula is a relative reference (e.g., A1 instead of $A$1).
3. Highlight the cell with the formula in it.
Click and hold on the bottom right corner of the highlighted cell.
Select the last row by press and hold shift key where you want the formula to appear.
Now press CTRL+D to fill the formula immediately. Hope this will help you