Forum Discussion
VLookup or IF Then or Match/Index? Not sure getting dup results using Vlookup
I am trying to search drop down column A in the Master sheet, match data and then pull that data's row into the corresponding sheet (car, sedan, suv).
I get the data to pull in using a Vlookup but ...
Hi,
VLOOKUP won't work in this case!
The lookup_value argument requires a unique identifier!
Otherwise, VLOOKUP will return the corresponding values of the first match cell and ignore the other dups.
So you will always get the same corresponding values.
The solution in your case is to use the Get & Transform Data (Aka Power Query) as Sergei mentioned before.
Please find the attached file to see this solution.
Also, one of the benefits of using Power Query is when adding new records in the master sheet, you can refresh the tables in the sub-sheets to update them with these new records.
Awesome -- Thank you!!!