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