=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