I have a sheet of values and have extracted one column, removed duplicates, and then filtered based upon what I need, leaving me with a new list of 'values of interest'.

I now want to go back to the original sheet and pull values from certain columns that match my new 'clean' list.

Hope the question makes sense - I can't find an explanation of how to use VLOOKUP or INDEX/MATCH to test an array for matches of multiple values at once.

Sorry that I can't upload a sample sheet right now.

Thanks.