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

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

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

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

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