Excel – extracting data based on another list


I have an Excel worksheet with two columns (name/ID) and then another list that is a subset of the names only from the larger aforementioned list. I want to go through the subset list and then pull the data from the larger list (name/ID) and put it somewhere else…essentially only grabbing the data from the larger list if the name is on the subset.

I tried using Filters, but couldn't get it work. Thoughts?


Best Solution

New Excel versions


Older Excel versions


That is: "If the value of A1 exists in the B column, display it here. If it doesn't exist, leave it empty."

Related Question