Leaving a cell blank

[Deaddog]

could someone tell me how to keep the #N/A out of the blank cells for this:

=INDEX('Data Table'!$A2:$J9999,MATCH(1,('Data Table'!$A2:$A9999=M3)*('Data Table'!$B2:$B9999=3),),MATCH("Bulk Schedule",'Data Table'!$A2:$J2,0))


Thanks

 

[Domski]

Try:

=IF(OR(ISNA(MATCH(1,('Data Table'!$A2:$A9999=M3)*('Data Table'!$B2:$B9999=3),)),ISNA(MATCH("Bulk Schedule",'Data Table'!$A2:$J2,0))),"",INDEX('Data Table'!$A2:$J9999,MATCH(1,('Data Table'!$A2:$A9999=M3)*('Data Table'!$B2:$B9999=3),),MATCH("Bulk Schedule",'Data Table'!$A2:$J2,0)))

Dom

 

[dave3009]

You'd probably use an IF/ISNA round about it

=IF(ISNA(yourformula), "", yourformula)

HTH


Dave