VLOOKUP All Matches with this Crazy Simple Trick

Ever want to VLOOKUP but show multiple matching results? The standard Excel VLOOKUP formula has a limitation and it will only show the first matching result. But what if you need to see all matches in one place?

In this video, let me present you a simple formula to get all matches in a list format.

More on VLOOKUP & Other functions (My Skillshare course):

Learn more about FILTER function:

Other ways to get multiple results with VLOOKUP:

Thank you for watching & reading. Have a beautiful day 😀🌞🌼

#VLOOKUP

[sonalinaralkar]

Sir, ur excels videos are so awesome and these videos are very helpful to me improve skills about excel.
Thank you Sir!!!!

[careeyam]

Thank you very much Chandoo

I watched your other video on 8 ways to report in pivot table and it help a great deal to prepare my report. God bless you

[msmadnesseverywhere]

Thank you so much for explaining this in such an easy manner. This is exactly what I was looking for :)

[mikeser]

If you want to display all sales values in the same cell, you can take his formula and put =SUM( in front of it

[DinoDelight]

Thats great, was try various formulas to do this

[HariKumar-runo]

Hi chandoo. Thumbnail showing vlookup. But content about filter function...😉😉😉

[izzatkiswani]

Hi
Its doable with vlookup to extract multiple matches .

[mahmoudhassan]

Sir, May Allah bless you >> In fact your simplification is awesome >> Thanks Chandoo

[Kishore-ctzs]

It was informative Mr.Chandoo, I love your name btw 😁

[thinkhelpservice]

this is exactly what I have been looking for however my work PC is not using EXCEL 365, how do I achieve this on a non 365

[sureshbabubabu]

Sir
I want same video with two different sheets with(with employee names repeated using filter and vlookup ) plz do a video

[shopinurhidayanti]

can u tell me how do I select excel rows at the same time? at minute 0:42 please. btw thanks for your video, is very good

[govardhanp]

Dear Chandoo, Thanks a lot for the very informative video. it is really simplifying our work.
I wanted to ask that, in this video, you are using D4 cell as base, so whatever you alter in D4, accordingly the results will be displayed below.
What if we have multiple D4 values to be extracted?
In other words, I have sheet A with multiple sales person names (eg. suresh, mahesh, ramesh), and sheet B with their sales data(eg: suresh data for 3 rows, mahesh data of 6lines, & ramesh data of 4 lines).. sheet B also has extra names which is not necessary . So into sheet A i need to extract all the sales data. I cannot do one by one as my data is huge. I want to lookup all the data from sheet B to sheet A in one shot, without altering D4(in ur video) everytime.
Appreciate if you can help. THanks

[Surajk]

Hi if we use countif with vlookup than it was showing multiple results

[sairakesh]

How to sum Ram Mahesh amount by using Vlookup ?

[prabhupbu]

Hi Chandoo.. I feel that pivot table data will serve the purpose of filter formula..?

[munaazna]

Why “sales” how to save table with name like that? On my excel thats not work

[srikanthm]

Hi chandoo it was around up for last times filter session 👍.

I would like ask any session on query function which is similar to SQL !?

[Adriaan.J.L]

I don’t think I’ll need it, but just for in case, what function can you then use for HLOOKUP?

[jayarpenaranda]

so it means this is not applicable on the basic excell?