find, Index?

[sylv1501]

I have the a number in A1 312. I want to find that number in column K
and enter the corresponding text in column L into cell A2. How do I
do that?

 

[Don Guillett]

Look in the help index for MATCH to find the row and then look for INDEX and
incorporate the match as the row. Or use VLOOKUP.

 

[Guest]

=VLOOKUP(A1,K:L,2,0)

Or

=IF(iSNA(VLOOKUP(A1,K:L,2,0)),"",VLOOKUP(A1,K:L,2,0))

will return blank if mo match