Had a better experience using CoPilot AI to help me with a stupid Excel formula. Got introduced to XLOOKUP which is way better than VLOOKUP. But still, all that human effort & energy to teach me one formula. Not a fan.

I am “my TikTok feed includes people arguing in the comments of a video about the merits of vlookup vs xlookup vs index match” years old.

XLOOKUP is only five years old. Give him a chance!

XLOOKUP is a beefed up VLOOKUP no need to nest index and match for example

This ^ Although I still usually use = [cell 1] & [cell 2] 🫣 Not sure about xlookup though. I've definitely used vlookup plenty of times.

Why bother when I don't have to next and just use XLOOKUP

You'll love XLOOKUP

If I ever learn what CONCAT and XLOOKUP are I'll throw myself off a cliff

Got annoyed with a guy at work today. You're 40 years old, and worked for years in sales, you've always used excel, you do reports, my brother in Christ how do you not know what CONCAT or XLOOKUP is, I'm embarrassed for you

Har ni någon favoritfunktion i excel? Min är nog xlookup, helvete vad den hjälpt mig att pussla ihop saker