Jan 24 2019 09:17 AM
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!
Jan 24 2019 12:07 PM
SolutionHi,
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
Jan 24 2019 12:25 PM
Yes! That's it! I had an extra set of parenthesis that changed the formula.
Thank you! @Sergei Baklan
Jan 24 2019 01:45 PM
You are welcome
Jan 24 2019 12:07 PM
SolutionHi,
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