A very visually pleasing walkthrough. Thank you for this information.

@SdMotion

Жыл бұрын

Thank you! Please share and follow my channel for more videos! Thanks again 🙏

Wonderful work here! Thank you!

Interesting presentation, Than you!

Very good, thanks!

ขอบคุณครับผม. (Thanks )

@SdMotion

Жыл бұрын

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...

Which version of Excel are you using?

Can u give hw to do total value if choosen East region Only region Sales is needed in xlookup

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?

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

Жыл бұрын

Hi, what excel version do you use? And could you please elaborate more about your query so that I could give you a solution.

@mohdtoufique7446

Жыл бұрын

@@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

@SdMotion

Жыл бұрын

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