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:
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.
Leave a Reply