Forum Discussion
mhapij
Mar 12, 2018Copper Contributor
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 ...
SergeiBaklan
Mar 12, 2018Diamond Contributor
Hi,
If that's only to copy filtered table to another sheet better to use Power Query (Get&Transform in 2016).
mhapij
Mar 12, 2018Copper Contributor
Thank you! I have never heard of this command so I will check it out. Much appreciated.