How can find match of one cell from a column of cells?

[Guest]

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

 

[Bernie Deitrick]

Mat,

In cell B1:

=VLOOKUP(A1,C14,2,False)

HTH,
Bernie
MS Excel MVP