XLOOKUP Advanced Function with Examples

Подписаться 14 тыс.

Просмотров 17 тыс.

50% 1

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

Опубликовано:

30 май 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 16

@joelabacherli1310 Год назад

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

@SdMotion Год назад

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

@tommoody782 3 года назад

Interesting presentation, Than you!

@relax9286 8 месяцев назад

Wonderful work here! Thank you!

@Luciano_mp Год назад

Very good, thanks!

@user-py5tc5bw1s Год назад

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

@SdMotion Год назад

Welcome ❤️

@asitmohanty3295 2 года назад

Which version of Excel are you using?

@ubaidillahmuhammad20 3 года назад

nice. always put pratised file in the description...

@chandramohan1418 2 года назад

Sir could pl solve my problem, in the last example-Dynamic ranges,if we calculate for each salesperson,what will be forumale.thankyu

@sureshskn Год назад

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

@mohdtoufique7446 Год назад

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