Comparing and Pasting

Hello,

I have 4 columns.

Col1---|---Col2---|---Col3--|---Col4----|
----------|------------|------------|-------------|
A............SSHH.......B...................
B............XXYY........C...................

Now the macro should compare Col1 and Col3. If any value is found in Col3, den paste the text present at Col2 in Col4.

For e.g. The macro compares Col1 and Col3. It finds B in Col3 and simultaneously it should paste the value XXYY in Col4 (i.e. beside B). It should look like shown below after macro runs.

Col1---|---Col2---|---Col3--|---Col4----|
----------|------------|------------|-------------|
A...........SSHH........B........XXYY....
B...........XXYY.........C...................


Can this be done using normal functions in Excel, or do i need to write a mcaro. If a macro is required, then can anyone provide a macro for this requirement.

Try

=IF(ISNA(INDEX($B$1:$B$13,MATCH($C1,$A$1:$A$13,0))),"",INDEX($B$1:$B$13,MATCH($C1,$A$1:$A$13,0)))

in cell D1.

This will only work if the values in column A are unique.