| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Value Found instead of a 1
Can anyone tell me how I can get this formula to return the Vaule of the Cell
that Matched instead of just returning the number 1? =IF(INDEX($W$2:$W$306,MATCH($AA13,$W$2:$W$306,0),1 )="#N/A",0,1) Thanks in Advance, Rob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Value Found instead of a 1
Surely, the value will be whatever is in AA13?
-- __________________________________ HTH Bob "Rob" wrote in message ... Can anyone tell me how I can get this formula to return the Vaule of the Cell that Matched instead of just returning the number 1? =IF(INDEX($W$2:$W$306,MATCH($AA13,$W$2:$W$306,0),1 )="#N/A",0,1) Thanks in Advance, Rob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Value Found instead of a 1
Unfortunately it is but it is the search for value. I am trying to get the
Found value. I'm trying to do that so I can get a value from an adjacent cell of a different colum. My Apologies for not mentioning that earlier... I was in a rush. :( "Bob Phillips" wrote: Surely, the value will be whatever is in AA13? -- __________________________________ HTH Bob "Rob" wrote in message ... Can anyone tell me how I can get this formula to return the Vaule of the Cell that Matched instead of just returning the number 1? =IF(INDEX($W$2:$W$306,MATCH($AA13,$W$2:$W$306,0),1 )="#N/A",0,1) Thanks in Advance, Rob |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Value Found instead of a 1
=INDEX($X$2:$X$306,MATCH($AA13,$W$2:$W$306,0),1)
-- __________________________________ HTH Bob "Rob" wrote in message ... Unfortunately it is but it is the search for value. I am trying to get the Found value. I'm trying to do that so I can get a value from an adjacent cell of a different colum. My Apologies for not mentioning that earlier... I was in a rush. :( "Bob Phillips" wrote: Surely, the value will be whatever is in AA13? -- __________________________________ HTH Bob "Rob" wrote in message ... Can anyone tell me how I can get this formula to return the Vaule of the Cell that Matched instead of just returning the number 1? =IF(INDEX($W$2:$W$306,MATCH($AA13,$W$2:$W$306,0),1 )="#N/A",0,1) Thanks in Advance, Rob |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Value Found instead of a 1
AHhhhhhh!!! I see the light he says. I feel a bit dumb for not knowing
that. Either way.... THANK YOU VERY MUCH! "Bob Phillips" wrote: =INDEX($X$2:$X$306,MATCH($AA13,$W$2:$W$306,0),1) -- __________________________________ HTH Bob "Rob" wrote in message ... Unfortunately it is but it is the search for value. I am trying to get the Found value. I'm trying to do that so I can get a value from an adjacent cell of a different colum. My Apologies for not mentioning that earlier... I was in a rush. :( "Bob Phillips" wrote: Surely, the value will be whatever is in AA13? -- __________________________________ HTH Bob "Rob" wrote in message ... Can anyone tell me how I can get this formula to return the Vaule of the Cell that Matched instead of just returning the number 1? =IF(INDEX($W$2:$W$306,MATCH($AA13,$W$2:$W$306,0),1 )="#N/A",0,1) Thanks in Advance, Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight Found Cell | Links and Linking in Excel | |||
| How to know location of cell found with MIN/MAX? | Excel Discussion (Misc queries) | |||
| skip to next cell if no value is found | Excel Discussion (Misc queries) | |||
| Change the appearance cell where Find criteria is found in a cell | Excel Discussion (Misc queries) | |||
| Need the cell next to one found through If Then | New Users to Excel | |||
Linear Mode
