“A better question is to ask if they use VLOOKUP or Index Match, and why?” The only right answer is neither of them! XLOOKUP, because it’s an Index Match wrapped into an IFERROR and the syntax is much cleaner
You would have qualified as the psycho who got the answer correct.
I have yet to hear somebody ask in an interview about XLOOKUP, probably because they reached levels that no longer require them to open Excel once XLOOKUP got added.
Same! Kind of crazy how firms think it’s ok to keep candidates in the dark for weeks, if not months at a time. Like you said, indicative of the firm you.
Good idea, I’ll when I do an update! Thanks for reading and commenting!
“A better question is to ask if they use VLOOKUP or Index Match, and why?” The only right answer is neither of them! XLOOKUP, because it’s an Index Match wrapped into an IFERROR and the syntax is much cleaner
You would have qualified as the psycho who got the answer correct.
I have yet to hear somebody ask in an interview about XLOOKUP, probably because they reached levels that no longer require them to open Excel once XLOOKUP got added.
Exactly on all fronts!
Same! Kind of crazy how firms think it’s ok to keep candidates in the dark for weeks, if not months at a time. Like you said, indicative of the firm you.
Good idea, I’ll when I do an update! Thanks for reading and commenting!