Nested IF Statement with VLOOKUP

Copper Contributor

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!

1 Reply

@JCPeterson13 

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.