Hi all

I have 2 worksheets one with a large set of data (wksheet1) and the other is the same data but filtered (wksheet2) to remove duplicates and some other filters applied.

What I want to do is to take each item in the filtered list and based on a condition set on column x in the original data worksheet return all the rows from the wksheet 1 (original dataset) where the condition matches.

An example:

wksheet1:
11, Red
23, Green
42, Blue
93, Blue
91, Orange

wksheet2:
11, Red
23, Green
42, Blue
91, Orange

So here I want the filter/condition to return me all the rows from
wksheet 1 (original dataset) where the color in wksheet2 is Blue.

The desired result would be:
42, Blue
93, Blue

Please could someone help me in how to do this with a VLOOKUP or another
excel lookup which seems suitable for this purpose?