VLOOKUP Return Multiple Matching Rows and Columns

Related blog post:

In this video, we'll discuss a way to simulate using VLOOKUP to return multiple matching rows and/or columns. What do you mean by "simulate" Jeff? Well, VLOOKUP is designed to return a single value, not multiple values. That is, VLOOKUP scans down the lookup range and stops at the first matching row ... ignoring any additional matching rows. Once VLOOKUP finds a matching row value, it shoots to the right to retrieve the related value from a single column. But let's say we want to return the values from multiple columns and all of the matching rows. Well, this is where VLOOKUP breaks down. So, we'll simulate this functionality by turning to Power Query.

[rioafero]

Awesome video! Easy to follow and I have just half the time for a major task and de-risking some work processes! Thank you!

[alexabro]

Thanks a lot for this video!!! This highly saved my time on a project.

[rgoins]

Just ruined my Saturday! Now I gotta try this for my work! Thanks!!

[fer.barajas]

Simple and straightforward. As good as a tutorial can be! Thanks!

[frenzzie]

i have been searching so crazy long for this solution, thank you very much, subscribed!

[gabrielnilo]

Than you, this is great!
I used it on multiple references that would return multiple values each.
You could imagine the pain that I went before finding this video, the scalability of this method is quite good! 👍

[danalariealmorales]

Your video was absolutely fabulous in teaching me how to do what I needed! Thank you so much for taking the time to record this.

[dinaaronson]

You're BRILLIANT, sir. this solved my problem perfectly. Thank you!!!!

[bt]

This was very slick. Probably best Excel video I've seen! Thank you!

[vipst]

Superb sir. I’ve been searching this for many months. Thanks.

[AffJanderson]

This was immensely helpful. This was the last step of a huge data sorting project and you helped make it a quick one! Appreciate it.

[yazo]

I have been trying to figure this out for longer than I even want to admit. Thank YOU!!!

[FusilAutomatique]

Brilliant tutorial. I came here after hours trying to bash a square VLOOKUP into a round data alignment, and was able to apply your method to an enormous spreadsheet within half an hour (the data needed some tidying). Thank you.

[Prathameshkulkarni]

I have never been more satisfied by the solution for my query than this. this was absolutely spot on what i wanted. Thank you :)

[eslamfahmy]

Thanks alot it's was a wonderful tutorial 😊

[molyviolet]

I really can't thank you enough. Amazing work, thank you.

[grendbelema]

great, being looking for this for some time now...got yourself a new subscriber

[barnabasocholla]

You are a life saver. This saved me tons of man hours. Very powerful tip and clear instruction

[ramzein]

very useful and this is what I was looking for, thanks im not how im gonna do this as have never done power query before :(

[maheskumar]

PERFECT. I have gone through number of video's and couldn't achieve the result that I was looking for.. however this one has awesomely helped me to get things done, really appreciate it, thank you.