In the 51st session of Chandoo.org podcast, let's discuss most frequently asked questions about VLOOKUP.
What is in this session?
In this podcast,
What is VLOOKUP?
What happens when VLOOKUP can't find the value?
Should my list be sorted?
Is VLOOKUP slower than INDEX + MATCH?
What if my list has multiple matches?
How to fetch 2nd / 3rd matching item?
How to fetch all matching items?
How to fetch items matching multiple conditions?
How to speed up VLOOKUP?
Why doesn't my VLOOKUP work?
What to do in case of errors?
Resources for you