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 way to use INDEX and MATCH, that I believe is supposed to work, but I am getting an #REF!. Below are screen shots which hopefully help show what I am trying to achieve.
I also have two data groups set up 'Alldata' is A4,E4:A100,E100 and 'Techs' is A4:A100
I have a table that lists all of the classes our technicians are taking, I want to be able to pull out the information by each technician and have a seperate tab for each of them.
3 Replies
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.
There's a few ways to do it.
My methods
1. INDEX array
2. FILTER (Works if you have 365 fully updated).
Sample attached.
