File Download: [ Ссылка ]
Learn Excel the FAST way -- [ Ссылка ]
Watch the VLOOKUP Hacks playlist here [ Ссылка ]
Subscribe here 👉 [ Ссылка ] and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
Watch VLOOKUP vs SUMIFS Playlist here [ Ссылка ]
Watch Dynamic Arrays playlist here [ Ссылка ]_
Watch Treasure Maps playlist here [ Ссылка ]
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.
![](https://s2.save4k.ru/pic/s3SK2Gqhj4M/maxresdefault.jpg)