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