XLOOKUP function in

[@NtobekoZungu]

Quick (non-time waster). Thanks 💪🏾

[@anacap007]

Excel's version of OUTER JOIN

[@malarkey0949]

Saving this!

[@navy1001001]

Maaan you are the best

[@next_gen_traders591]

omd you saved me !!!!

[@ThanksFriend]

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

[@mubimuthu9392]

THANK YOU THANKYOU THANK YOUTHANKYOUU

[@pacelligt6722]

Where is Jim on the sales rep tab??

[@silverturtle00]

Thank you

[@mahekmemon6447]

Tysm tysm tysm

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

[@matricus]

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