using IF(ISERROR) statements with true/false outcome in an IF statement

Hello and Greetings, I have two formulas: =IF(ISERROR(VLOOKUP(D6,'SKU list'!J:J,1,FALSE)),FALSE,TRUE) =IF(ISERROR(VLOOKUP(D196,CTO!A:A,1,FALSE)),FALSE,TRUE) Both work perfectly and retur...

excel

Formulas and Functions

SergeiBaklan

Jan 24, 2019

Hi,

Your current formula is

=IF(FT2="Accessories",
   (
      IF(ISERROR(VLOOKUP(D2,'SKU list'!J:J,1,FALSE)),FALSE,TRUE),
      (IF(ISERROR(VLOOKUP(D178,CTO!A:A,1,FALSE)),FALSE,TRUE))
   )
)

If you update on

=IF(FT2="Accessories",
   IF(ISERROR(VLOOKUP(D2,'SKU list'!J:J,1,FALSE)),FALSE,TRUE),
   IF(ISERROR(VLOOKUP(D178,CTO!A:A,1,FALSE)),FALSE,TRUE)
)

perhaps it will work, I didn't test

Forum Discussion

using IF(ISERROR) statements with true/false outcome in an IF statement

Resources