XLOOKUP function in

[@NtobekoZungu]

Quick (non-time waster). Thanks 💪🏾

[@nvsportscards7199]

An actual good use of Xlookup. The other videos out there use xlookup in the same way as vlookup

[@inspectorgadget8234]

So smart, except for down selecting the entire colomn..double click on right corner first top cell to auto select entire column

[@anacap007]

Excel's version of OUTER JOIN

[@malarkey0949]

Saving this!

[@pacelligt6722]

Where is Jim on the sales rep tab??

[@ThanksFriend]

Is there a way to do this but retain all colors from the return_array?

[@user-zs3dh8ck3w]

Ahh you're the best!

[@nabilshaikh2525]

Saved my life... thanks

[@navy1001001]

Maaan you are the best

[@hammadsiddiqui4259]

Xlookup isn't available with previous versions

[@sassouusasoo3607]

No

[@TurboTroller]

Yeah and excel doesn’t work if you don’t have it installed on your computer, what’s your point

[@NikhilSharma-fh9uh]

​​@@TurboTrollerWe are still using excel 2019 ? what are you trying to say, please elaborate

[@juancarlos1604able]

🤣@@TurboTroller

[@Thanh_tam]

What’s excel version to able to use xlookup function

[@next_gen_traders591]

omd you saved me !!!!

[@mubimuthu9392]

THANK YOU THANKYOU THANK YOUTHANKYOUU

[@akayneee]

Oh that's why, it's only on 365

[@ritikjha3212]

Thanks

[@silverturtle00]

Thank you

[@matricus]

And Index/Match is a better version of XLookup and does work in older versions.

[@neversettle9920]

ruclips.net/user/shortsb4wXvocHwLg

[@mahekmemon6447]

Tysm tysm tysm