Mat,

In cell B1:

=VLOOKUP(A1,C1:D4,2,False)

HTH,
Bernie
MS Excel MVP


"Mat" wrote in message
...
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