| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find 2nd, 3rd, etc Result with index/match | Excel Worksheet Functions | |||
| Index function to find nth occurrence | Excel Worksheet Functions | |||
| Use find with Index and Match | Excel Worksheet Functions | |||
| Using INDEX to find the match | Excel Discussion (Misc queries) | |||
| INDEX, FIND.... MATCH???? | Excel Discussion (Misc queries) | |||
Linear Mode
