find, Index?

S

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?
 
D

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.
 
T

Toppers

=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
 
Top