Need to compare values of two columns and return the adjacent value to a 3rd

Originally Posted by kvsrinivasamurthy

Pl post a workbook with dummy data with before and after format.

It was my first post, I'll keep it in mind for the next time.

Originally Posted by ConneXionLost

How about something like:

=IF(COUNTIF($A$2:$A$10,C2),VLOOKUP(C2,$A$2:$B$10,2,0),"")

Adjust ranges to suit.

Cheers,

Thank you so much, that worked exactly as I needed it.