How do I go about adding an OR argument to this formula:
=IF(ISNA(MATCH(Data!B3,'parts'!A2:A50,0)),"NO PRINT",INDEX('parts'!A2:L50,MATCH(Data!B3,'parts'!A2:A50,0,12))
If the match returns a value of 0 I also want the result to be "NO PRINT".
Thanks,
Skip
=IF(ISNA(MATCH(Data!B3,'parts'!A2:A50,0)),"NO PRINT",INDEX('parts'!A2:L50,MATCH(Data!B3,'parts'!A2:A50,0,12))
If the match returns a value of 0 I also want the result to be "NO PRINT".
Thanks,
Skip