CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered

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

The post CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.