This right here is maybe the most important thing anyone can learn in Excel.

The second most important thing is how to use vlookup() for cross-sheet lookups, using a column in the other sheet as a foreign key.

Stop using vlookup. Use index and match, either through named references as Joel does it or just manually even. It's more powerful, faster and less prone to failure because vlookup relies on an assumed order of sorting but most people won't know this and will wonder why it's cocking up.

You really should use MATCH with last argument 0 (exact match) and use it only within IF(ISERROR:

IF(ISERROR(MATCH(Key;Keys;0));"null";INDEX(Values, MATCH(Key; Keys))))

Fourth argument, set to false.

Fixes the ordering issue.

VLOOKUP has a parameter for exact matches.

> vlookup

I guess you didn't watch the video?

I did, and I understand why he mentions an alternate way of doing that.

I still prefer vlookup.

If they made it optional to use column and e.x. made it possible to use column name references, i'd go back to love it too.

But manually counting columns is annoying.