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.