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.
Bookmarks