Column comparison

[march]

Hi Guys,

In column A I have a type with column B being its price. In column C I have a list of other types which I need to find in column A. Simple enough compare C to A.

What I need is once the match between C and A is found, the value in B is placed into D for the matching type.

Therefore if there is a list of 200 in Column A and only 50 in column C then column D will have the prices from column B.

I hope this makes sense.

Thanks,

 

[VoG]

Try in D1 copied down

=VLOOKUP(C1,A$1:B$1000,2,FALSE)

 

[march]

You bloody legend!!

Thanking you!