Dear Friends,

My data is as follows;

Col A Col B Col C Col D
RED Yellow Y
Gre Black E
Pink RED F
Yellow Brown G

I have the above data, How can i match Col A1(RED) to the data in column C
(Yellow to Brown) and if col A1 (RED) matches to any cell in Col C (example
matches col C RED) then pickup the data from subsequent Col D (example col D
F) and place in col B1

Hope i have not confused youll in asking my question.

Regards