Forum Discussion
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
- SergeiBaklanDiamond 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
- 4ck3r360Copper Contributor
- SergeiBaklanDiamond Contributor
You are welcome