XLOOKUP Function in Excel

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
www.udemy.com/...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/exc...
🍉Read my articles on Excel
xlncad.com/
🍏Playlist for Shorts on Excel
• Short videos on Excel ...
#excelshorts #exceltip #exceltrick

[@JonnyCrowe95]

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

[@ytpre1631]

This is the best explanation of xlookup !!!!

[@janellentim]

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

[@eleseocapellan2149]

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

[@sabeelahmed1157]

Whichever Tony comes first, it will return the value of it

[@motivation_m00d]

I m doing this is amazing

[@IAABC]

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

[@mayjanfaithtolentino5013]

Simple but understandable! Thank you!

[@shivanmohyaddin]

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 )

[@PraveenKJ.]

But the names are different right. So, it's gonna sort according to the names

[@jaisonge]

Wanted to know How is this different from Vlookup

[@charmebenson4852]

Xlookup can look left or right, it defaults to exact match and it combines vlookup and hlookup

[@akshatgulati7460]

Your non complex index match function

[@galaxycat7960]

Vlookup has more technical rules you have to follow to essentially match and return your output.
Honestly xlookup is easier and much more user friendly

[@rohanshxtty]

@@galaxycat7960 for me vlookup was easy, but never tried xlookup. Gonna try from today

[@unknownfoodies8542]

THE LOOKUP VALUE SHOULD BE IN FIRST COLUMN FOR VLOOKUP BUT FOR XLOOKUP THIS RULE IS NOT APPLICABLE

[@villagefishing957]

Xlookup function are not available my pc

[@manukrishna4010]

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

[@ramakantarana3400]

Thank you

[@cristinaybanez-kami314]

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

[@allenjohnthomas5464]

XLOOKUP not available

[@pahuldeepsingh3938]

Thank you sir 😊

[@rc1800]

goated video, thank you

[@azgamesedits9496]

Me used Ctrl+F

[@sabaribrozz8682]

Sooo good... ❤️

[@afsar0066]

It's like Index and match function

[@alamzebkhan8328]

But it's much better than that...

[@robertodhiambo6148]

Very helpful

[@rizwanhanif2826]

Wrong formula is not working

[@jonayfool]

How all excel clips should be🫡

[@StillHungry7554]

How I find Excel job?

[@satwindersinghsidhubrar]

Thanks

[@stardomee]

easier than vlookup

[@Captainsavvy]

Thank you ❤

[@twainego6059]

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

[@prince93047]

Work office 365

[@tusharguptamusic]

Amazing,Very Useful

[@Sakshi-gk9cw]

D15 kaise aaya sir?

[@kdivya8316]

sir,Table array and lookup array are same or different

[@hypernarutoff7111]

i think different table arrey mai pura table select krna padta hai or lookup arrey mein jo naam select kra hai uske row ko krna hai

[@Shameervsl]

Bracket close cheyyandey

[@Shameervsl]

Formula is not complete and not working

[@AjayAnandXLnCAD]

Are you sure that you have XLOOKUP function? Which version of Excel are you using?

[@Shameervsl]

@@AjayAnandXLnCAD Sorry the formula I am using with table arry number and all same like before now its working thanks for your time

[@Shameervsl]

now its easy no need to count numbers and reverse also possible, Thanks for your valuable information

[@twainego6059]

Formula is not working where is the problem

[@mohamedaziz2583]

Nice

[@modassiraslam5960]

best video

[@rodrigovalerio9548]

Very useful!

[@RajKumar-ei7tc]

Thanks man

[@memediesel]

Not working 👎🏻