VLOOKUP Return Multiple Matching Rows and Columns

File Download: https://www.excel-university.com/yt_s3sk2gqhj4m/ 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/vlookup-return-multiple-matching-rows-and-columns 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.

• #education
• #excel_university
• #jeff_lenning