| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another nesting issue
Does anyone know how I can get information from a range of cells more than
nine rows? Example If a name shows up within a range from range D9 through D20 then enter whatever is in the cell in column F but the same row as the name shows up on? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another nesting issue
Look in the help index for MATCH. Then look for INDEX and nest your match
within the index. -- Don Guillett Microsoft MVP Excel SalesAid Software "Ed Davis" wrote in message ... Does anyone know how I can get information from a range of cells more than nine rows? Example If a name shows up within a range from range D9 through D20 then enter whatever is in the cell in column F but the same row as the name shows up on? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another nesting issue
Sorry I do not understand what I need to do here.
Thanks "Don Guillett" wrote in message ... Look in the help index for MATCH. Then look for INDEX and nest your match within the index. -- Don Guillett Microsoft MVP Excel SalesAid Software "Ed Davis" wrote in message ... Does anyone know how I can get information from a range of cells more than nine rows? Example If a name shows up within a range from range D9 through D20 then enter whatever is in the cell in column F but the same row as the name shows up on? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another nesting issue
OK I figured it out but I now have another problem.
This is the formula I am using. =INDEX(C$6:F$14,MATCH(C34,$C$6:$C$14,0),3) However, if the name in c34 does not exist it gives me the following: #N/A Is there a way to not get the N/A message? Thanks in advance. "Don Guillett" wrote in message ... Are you saying that you don't know how to use Excel help? -- Don Guillett Microsoft MVP Excel SalesAid Software "Ed Davis" wrote in message ... Sorry I do not understand what I need to do here. Thanks "Don Guillett" wrote in message ... Look in the help index for MATCH. Then look for INDEX and nest your match within the index. -- Don Guillett Microsoft MVP Excel SalesAid Software "Ed Davis" wrote in message ... Does anyone know how I can get information from a range of cells more than nine rows? Example If a name shows up within a range from range D9 through D20 then enter whatever is in the cell in column F but the same row as the name shows up on? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another nesting issue
Try this:
=IF(ISNA(MATCH(C34,$C$6:$C$14,0)),"",INDEX(C$6:F$1 4,MATCH(C34,$C$6:$C $14,0),3)) Gives you a blank cell instead - you could change the "" to "warning" or some-such. Hope this helps. Pete On Sep 2, 4:47*pm, "Ed Davis" wrote: OK I figured it out but I now have another problem. This is the formula I am using. =INDEX(C$6:F$14,MATCH(C34,$C$6:$C$14,0),3) However, if the name in c34 does not exist it gives me the following: #N/A Is there a way to not get the N/A message? Thanks in advance. "Don Guillett" wrote in message ... Are you saying that you don't know how to use Excel help? -- Don Guillett Microsoft MVP Excel SalesAid Software "Ed Davis" wrote in message ... Sorry I do not understand what I need to do here. Thanks "Don Guillett" wrote in message ... Look in the help index for MATCH. Then look for INDEX and nest your match within the index. -- Don Guillett Microsoft MVP Excel SalesAid Software "Ed Davis" wrote in message ... Does anyone know how I can get information from a range of cells more than nine rows? Example If a name shows up within a range from range D9 through D20 then enter whatever is in the cell in column F but the same row as the name shows up on?- Hide quoted text - - Show quoted text - |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another nesting issue
That did it.
Thank you very much. "Pete_UK" wrote in message ... Try this: =IF(ISNA(MATCH(C34,$C$6:$C$14,0)),"",INDEX(C$6:F$1 4,MATCH(C34,$C$6:$C $14,0),3)) Gives you a blank cell instead - you could change the "" to "warning" or some-such. Hope this helps. Pete On Sep 2, 4:47 pm, "Ed Davis" wrote: OK I figured it out but I now have another problem. This is the formula I am using. =INDEX(C$6:F$14,MATCH(C34,$C$6:$C$14,0),3) However, if the name in c34 does not exist it gives me the following: #N/A Is there a way to not get the N/A message? Thanks in advance. "Don Guillett" wrote in message ... Are you saying that you don't know how to use Excel help? -- Don Guillett Microsoft MVP Excel SalesAid Software "Ed Davis" wrote in message ... Sorry I do not understand what I need to do here. Thanks "Don Guillett" wrote in message ... Look in the help index for MATCH. Then look for INDEX and nest your match within the index. -- Don Guillett Microsoft MVP Excel SalesAid Software "Ed Davis" wrote in message ... Does anyone know how I can get information from a range of cells more than nine rows? Example If a name shows up within a range from range D9 through D20 then enter whatever is in the cell in column F but the same row as the name shows up on?- Hide quoted text - - Show quoted text - |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another nesting issue
You're welcome, Ed - thanks for feeding back.
Pete On Sep 2, 7:50*pm, "Ed Davis" wrote: That did it. Thank you very much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting if/or/and | Excel Worksheet Functions | |||
| OR Nesting? | Excel Discussion (Misc queries) | |||
| nesting issue in functions | Excel Worksheet Functions | |||
| IF - Nesting... almost got it - need a bit of help | Excel Worksheet Functions | |||
| nesting sum if and | Excel Worksheet Functions | |||
Linear Mode
