Let's say I have the following:
Column A Column B Column C
Orange 100 200
Black 201 300
Yellow 301 400
Now, I have a different worksheet that has a column of values. I want to search for each value in the ranges of Cols B and C and return the color that is in Col A.
For example is as follows and Col A is what I am searching for and want to derive Col B:
Column A Column B
157 Orange
188 Orange
255 Black
Is there a way I can do this?
Bookmarks