Need formula for if cell matches cell in different column to display corresponding cell

[portokie]

I have three columns, columns A and B have corresponding data and there are no duplicates. Column C contains matches from column A and does contain duplicates.

I need a formula in column D so that if a cell in column C matches a cell in column A, it will display the corresponding cell in column B. Thanks!

[6StringJazzer]

Try this:

Please Login or Register  to view this content.

[Jonmo1]

Try

=VLOOKUP(C2,$A$2:$B$100,2,FALSE)

[portokie]

First solution worked perfectly, many thanks to both of you!