View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default 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