38 min

CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered Chandoo.org Podcast - Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel

    • Business

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

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

38 min

Top Podcasts In Business