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.