VLOOKUP Return Multiple Matching Rows and Columns
File Download: https://www.excel-university.com/yt_s...
Learn Excel the FAST way -- https://www.excel-university.com/yt
Watch the VLOOKUP Hacks playlist here • VLOOKUP Hacks Series
Subscribe here 👉 https://bit.ly/exceluniversityyoutube and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
Watch VLOOKUP vs SUMIFS Playlist here • VLOOKUP vs SUMIFS Series
Watch Dynamic Arrays playlist here • Dynamic Arrays Series
Watch Treasure Maps playlist here • Treasure Maps Series
Related blog post:
https://www.excel-university.com/vloo...
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.