The column order thing is pretty annoying but IMO the worst thing about vlookup is that you have to remember to set the last parameter to FALSE for pretty much

The column order thing is pretty annoying but IMO the worst thing about vlookup is that you have to remember to set the last parameter to FALSE for pretty much every single vlookup you ever do. (the default of TRUE is some backwards-to-the-80s-compatible behaviour where it expects the lookup column to be sorted and will return the wrong answers if it isn't, plus will return matches even if the data you're looking up isn't there - the closest match if your data is sorted, but it probably isn't, and "closest" may not even mean anything...)