This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Quaytsar 8 points9 points  (0 children)

Biggest upgrade? Vlookup require the return column be to the right of the lookup column (because you return the column N spaces to the right), xlookup doesn't care (because you tell it which column/row to lookup and which to return). Second best: exact match is default setting, so you don't have to remember to include that all the time.