=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



"Don Guillett" wrote:

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
oups.com...
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?