File Download: excel-university.com/yt_s3sk2gqhj4m/

Learn Excel the FAST way -- excel-university.com/yt
Watch the VLOOKUP Hacks playlist here youtube.com/playlist?list=PLg6394TGLU5EwVI-6MxpSZOVcoz9eEPVI

Subscribe here 👉 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 youtube.com/playlist?list=PLg6394TGLU5EprSnwbRF8_jCVQKde7cjr

Watch Dynamic Arrays playlist here youtube.com/playlist?list=PLg6394TGLU5FmzOe_Pb-zapkM4cX6PDC_

Watch Treasure Maps playlist here youtube.com/playlist?list=PLg6394TGLU5FTN2vOk-J55wsCej9l-8Dn

Related blog post:
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.

• VLOOKUP Return Multiple Matching Rows and Columns ( Download)
• Excel VLookup to Return Multiple Matches ( Download)
• Excel - VLOOKUP, Return Multiple Columns, Advanced Lookups ( Download)
• Vlookup Trick for multiple columns ( Download)
• How to Use VLOOKUP with Multiple Columns in Excel - Step by Step Guide ( Download)
• XLOOKUP - Return Multiple Columns (Values) in Excel ( Download)
• Return Multiple Match Results in Excel (2 methods) ( Download)
• VLOOKUP All Matches with this Crazy Simple Trick ( Download)
• Multiple Columns Vlookup in Excel - VLOOKUP, Return Multiple Columns Values #Vlookup #excel #formula ( Download)
• Unlock the Power of Vlookup : Multiple Values, Criteria & Columns - Excel Magic! #shorts #vlookup ( Download)
• Lookup and Return Multiple Results into One Cell Separated by Comma or Similar Delimiter ( Download)
• Using VLOOKUP on multiple columns ( Download)
• MS Excel LOOKUP Formula: Return Multiple Values ( Download)
• Lookup & Return Multiple Values in One Cell in Excel (Easy Formula) ( Download)
• Cool VLOOKUP Trick! How to Return Selected MULTIPLE Columns #shorts ( Download)