just put iferror around it
=iferror(MATCH(1,(DRAWS!$R$20:$R$4839=$B48)*(DRAWS!$S$20:$S$4839=J$42),0)-1,"") for blank
or
=iferror(MATCH(1,(DRAWS!$R$20:$R$4839=$B48)*(DRAWS!$S$20:$S$4839=J$42),0)-1,0) for 0
just put iferror around it
=iferror(MATCH(1,(DRAWS!$R$20:$R$4839=$B48)*(DRAWS!$S$20:$S$4839=J$42),0)-1,"") for blank
or
=iferror(MATCH(1,(DRAWS!$R$20:$R$4839=$B48)*(DRAWS!$S$20:$S$4839=J$42),0)-1,0) for 0
Excel Workbook | |||
---|---|---|---|
AA | |||
22 | 107 | ||
F536 DB |