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
|