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.