Jul 27 2019
10:20 PM
- last edited on
Feb 01 2023
10:31 AM
by
TechCommunityAP
Jul 27 2019
10:20 PM
- last edited on
Feb 01 2023
10:31 AM
by
TechCommunityAP
Currently have an IFERROR statement written with 2 arguments and looking to add a 3rd argument. Having issues implementing the 3rd argument correctly.
Here is what it is currently....
=IF(C5="Pick-Your-Own",(IFERROR((VLOOKUP(B5,'Package Pricing'!$J$3:$K$21,2,FALSE)*I5)+(VLOOKUP(B5,'Package Pricing'!$J$22:$K$40,2,FALSE)*J5)+(VLOOKUP(B5,'Package Pricing'!$J$41:$K$59,2,FALSE)*K5),"$0")*1),IFERROR(VLOOKUP(B5,'Package Pricing'!$J$60:$K$78,2,FALSE),"$0")*1)
Looking to add....
IFERROR(VLOOKUP(B5,'Package Pricing'!$J$79:$K$84,2,FALSE),"$0")*1)
Any help is appreciated!
Aug 04 2019 11:52 PM
First , if you post Excel related questions in the following page meant for Excel , you might get a quicker solution.
https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat
Coming to you question, it is best if you could upload your worksheet with some sample data. Could you please explain what are you trying to do with nested IF condition ? it looks like you are trying to return a value if you do not get a match from J3:J78 rows. if that is is the case why not change teh previous VLOOKUP call?
IFERROR() has an "else" part, i.e the 2nd argument , typically you should be able to achive the results with your condition in this part.