Forum Discussion
VLOOKUP with Identical Lookup Values and multiple columns
I just figured out VLOOKUP and was able to get the information to pull up for the first instance of a lookup value, but I need multiple instances to pull up. I tried doing some research and found a w...
From this point of view VLOOKUP and INDEX/MATCH work identically, they return first and only one found value. An error since you use MATCH incorrectly.
There are another techniques to pickup multiple records which meet the same criteria, from Power Query to formulas approach. But that's hard to explain without sample file. You may google for the patterns or we may help if you submit sampe file removing sensitive information from it.