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
@@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
A very visually pleasing walkthrough. Thank you for this information.
Thank you! Please share and follow my channel for more videos! Thanks again 🙏
Wonderful work here! Thank you!
Interesting presentation, Than you!
Which version of Excel are you using?
Thanks
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
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?
Very good, thanks!
Can u give hw to do total value if choosen East region Only region Sales is needed in xlookup
ขอบคุณครับผม. (Thanks )
Welcome ❤️
Sir could pl solve my problem, in the last example-Dynamic ranges,if we calculate for each salesperson,what will be forumale.thankyu
nice. always put pratised file in the description...
Kindly load a video 4-way lookup by xlookup
Please check my previous videos on Advanced XLOOKUP Tutorial ! Good luck