XLOOKUP Function in Excel

preview_player
Показать описание
How to use the XLOOKUP Function in Excel to perform a lookup into the right side as well as the left side.

🍐Join my online course on Excel Tables

🍓Download my free eBook on Excel Macros

🍇Check these Books on Excel

🍉Read my articles on Excel

🍏Playlist for Shorts on Excel

#excelshorts #exceltip #exceltrick
Рекомендации по теме
Комментарии
Автор

There's 16 minute tutorials that basically convey the same info. You're a hero and a cool

JonnyCrowe
Автор

Finally a simple explanation. May you and all of your descendants have a wonderful life. ❤

janellentim
Автор

This is the best explanation of xlookup !!!!

ytpre
Автор

👍 your videos are helping a lot, thank you.❤

manukrishna
Автор

Xlookup function are not available my pc

villagefishing
Автор

Hi, i need help with xlookup spill error.. can u show video about it? Thank you

cristinaybanez-kami
Автор

Wanted to know How is this different from Vlookup

jaisonge
Автор

Can you please do it by one formula, what I meant is, just by copying formula of salary, I should get for Designation

IAABC
Автор

It's like Index and match function

afsar
Автор

what will happen if you have more than one Tony name in the cell?

eleseocapellan
Автор

What if you wrote ( CAD designer ) which value it would give you as his salary since he has 2 different salaries in salary column ( 21, 000 and 20, 000 )

shivanmohyaddin
Автор

sir, Table array and lookup array are same or different

kdivya
Автор

Formula is not working where is the problem, I'm using excel 2019

twainego