That works. What about mutiple occurrences?

"muddan madhu" wrote:

try this

put this formula in F2

=INDEX(A2:A8,MATCH(E2,C2:C8,0),0)




On Nov 16, 12:56 am, Bill wrote:
I have the following 3 columns of data
000 0.198407405 PO3
001 0.207502916 CV3
002 0.984589896 CV3
003 0.715903627 FB2
It goes a lot further. I want to create a formula for another column that
will find a data point out of column 3, but enter the corresponding data from
column 1. ie: find FB2 in Column 3, but 003 is outcome.