Related Posts
This made me chuckle.

Additional Posts in Excel Genius
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
This made me chuckle.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site

Scan your QR code to download
Fishbowl app on your mobile

XLOOKUP all the way
True story
Wait till you hear about XLOOKUP
Wrapping in an IFNA to handle exceptions and making sure you put the “FALSE” flag at the end of the V/H/XLOOKUP call should make it work 100% of the time.
I used to be an index match person but I have since fully joined team XLOOKUP
Yeah x lookup is great. Index match has two advantages, but one big disadvantage.
+ Faster (if using 10K plus rows and multiple lookups, this is relevant, and Xlookup is actually the slowest lookup function)
+ Index Match Match is an easier syntax than the row/array lookup of xlookup
- For standard lookups, xlookup has way easier syntax
I’m an INDEX MATCH girlie ‘til the day I die - I even prefer it over XLOOKUP
Mans been working hard towards mastering VLOOKUP when XLOOKUP has been out for over 5 years
Index Match all the way
It’s 2024 we XLOOKUP
Index(Match) for the win
Touché
That is some quality vintage meme making right there