Forum Discussion

4ck3r360's avatar
4ck3r360
Copper Contributor
Jan 24, 2019
Solved

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 return "false" for items not in the referenced lists.

 

What I want to do is put them together in a new IF statement that says:

 

If (cell reference)="Accessories", use stmt 1, otherwise use stmt 2.

 

I did this but it doesn't work:

 

=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))))

 

The error says one of the values is the wrong data type.

 

Any ideas?

 

Thanks!

  • 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

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    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

Resources