Cell Value Found instead of a 1

[Rob]

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

 

[Bob Phillips]

Surely, the value will be whatever is in AA13?

 

[Rob]

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]

=INDEX($X$2:$X$306,MATCH($AA13,$W$2:$W$306,0),1)

 

[Rob]

AHhhhhhh!!! I see the light he says. I feel a bit dumb for not knowing
that. Either way.... THANK YOU VERY MUCH!