Hi I've been using this formula to return data from a cell in another sheet, ATK1 is a cell with a date in it but when the cell I'm trying match has no data it is returning the date from ATK1, is there a way to return a blank or zero?
=INDEX(EXAM!$AB$2:$CL$13,MATCH(ATK1,EXAM!$AB$2:$CL$2,0),1)
Thanks
Ian
Bookmarks