Just a little help

roughleg

Board Regular
Joined
Jun 21, 2004
Messages
181
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
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

thunderfoot

Board Regular
Joined
May 28, 2004
Messages
229
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

Board Regular
Joined
Jun 21, 2004
Messages
181
Thanks, for the response. It looks good. I'll give it a whirl.
Skip
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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))
 

Watch MrExcel Video

Forum statistics

Threads
1,118,109
Messages
5,570,246
Members
412,312
Latest member
linister
Top