The Guide to VLOOKUP



I call VLOOKUP the “duct tape of Excel” because it can mend and join practically any sets of data.

Introductory Slideshare:

Here are a few of my top posts on VLOOKUP:

Why Vlookup?

Vlookup: the Mechanics

An even better Vlookup: IFERROR

#Vlookupproblems: The Zoolander Problem

#VlookupProblems: Cells Formatted as Text

A Better Vlookup: Anchored Cell Reference

Want more even more VLOOKUP tips? Check out my course, “Hired with Excel: What Every Analyst Needs to Know.”

Because learning VLOOKUP could get you a job.


Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: