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 ...
In addition, if work with formulas that could be
=IFERROR(INDEX(Table1[#Data],AGGREGATE(15,6,ROW(Table1[#Data])/(Table1[Category]=$F$1),ROWS(Master!$A$2:Master!$A2))-ROW(Table1[[#Headers],[Category]]),1),"")
If source master is not structured as Table that could be a range (Master!$B$2:$D$11 instead of Table1[#Data]).
