Here is an introductory Slideshare to my Guide to VLOOKUP.
It’s one thing to know the mechanics, another to understand WHY we need to know it. VLOOKUP’s importance lies in the disperse nature of data.
Rarely does it come pre-packaged, for as much of a push as there is for “data warehouses” and “data lakes.”
VLOOKUP, like duct tape, is a fast, easy way to slap things together effectively.
(Pre-emptive INDEX/MATCH comment — VLOOKUP is what people search for. It’s how I can help. Capisce?)