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.
View all posts by Chandoo