Just a little help

[roughleg]

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

 

[thunderfoot]

Try this ...

=IF(or(MATCH(Data!B3,'parts'!A2:A50,0)=0,ISNA(MATCH(Data!B3,'parts'!A2:A50,0))),"NO PRINT",INDEX('parts'!A2:L50,MATCH(Data!B3,'parts'!A2:A50,0,12))

 

[roughleg]

Thanks, for the response. It looks good. I'll give it a whirl.
Skip

 

[barry houdini]

You could probably use VLOOKUP instead of INDEX/MATCH?

=IF(OR(ISNA(MATCH(Data!B3,'parts'!A2:A50,0)),VLOOKUP(Data!B3,'parts'!A2:L50,12,0)=0),"No Print",VLOOKUP(Data!B3,'parts'!A2:L50,12,0))