Need Help with Microsoft Excel

Hi all,

I am new to writing formulas in Excel, This is what I want to do

There are 3 columns A B and C. A has numeric values and B and C has alphanumeric values,  A and B have 10 values and C has 20 values. The Values in C, also exist in B, but are repeated twice or more . So if have to compare the values in C with B and if a match exists, then I need the corresponding value of A to be written to the new Column D.

For Eg : if C(2)=B(3) then D(2) =A(3)


In reality I have more than 10 values

Any help would be appreciated.



Thanks,
Madhava