VLOOKUP Multiple Matches – Trick

We all know VLOOKUP can match first result. But what if you want all the matching results in a cell? Simple, use this trick.

In this lesson

  • Quick re-cap of VLOOKUP, INDEX+MATCH
  • Demo of multi-result lookup
  • Understanding TEXTJOIN function
  • Using TEXT to convert data formats
  • Closing remarks

Watch this lesson [8 mins]

Author: Chandoo

My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions. I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here. I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.