find, Index?
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? |
find, Index?
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? |
find, Index?
=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? |
All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com