Home

Nested IF Statement with VLOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-776406%22%20slang%3D%22en-US%22%3ENested%20IF%20Statement%20with%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776406%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3ECurrently%20have%20an%20IFERROR%20statement%20written%20with%202%20arguments%20and%20looking%20to%20add%20a%203rd%20argument.%20Having%20issues%20implementing%20the%203rd%20argument%20correctly.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EHere%20is%20what%20it%20is%20currently....%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3DIF(C5%3D%22Pick-Your-Own%22%2C(IFERROR((VLOOKUP(B5%2C'Package%20Pricing'!%24J%243%3A%24K%2421%2C2%2CFALSE)*I5)%2B(VLOOKUP(B5%2C'Package%20Pricing'!%24J%2422%3A%24K%2440%2C2%2CFALSE)*J5)%2B(VLOOKUP(B5%2C'Package%20Pricing'!%24J%2441%3A%24K%2459%2C2%2CFALSE)*K5)%2C%22%240%22)*1)%2CIFERROR(VLOOKUP(B5%2C'Package%20Pricing'!%24J%2460%3A%24K%2478%2C2%2CFALSE)%2C%22%240%22)*1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ELooking%20to%20add....%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EIFERROR(VLOOKUP(B5%2C'Package%20Pricing'!%24J%2479%3A%24K%2484%2C2%2CFALSE)%2C%22%240%22)*1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-776406%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787670%22%20slang%3D%22en-US%22%3ERe%3A%20Nested%20IF%20Statement%20with%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787670%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383255%22%20target%3D%22_blank%22%3E%40JCPeterson13%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20%2C%20if%20you%20post%20Excel%20related%20questions%20in%20the%20following%20page%20meant%20for%20Excel%20%2C%20you%20might%20get%20a%20quicker%20solution.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fct-p%2FExcel_Cat%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EComing%20to%20you%20question%2C%26nbsp%3B%20it%20is%20best%20if%20you%20could%20upload%20your%20worksheet%20with%20some%20sample%20data.%26nbsp%3B%20Could%20you%20please%20explain%20what%20are%20you%20trying%20to%20do%20with%20nested%20IF%20condition%20%3F%20it%20looks%20like%20you%20are%20trying%20to%20return%20a%20value%20if%20you%20do%20not%20get%20a%20match%20from%20J3%3AJ78%20rows.%20if%20that%20is%20is%20the%20case%20why%20not%20change%20teh%20previous%20VLOOKUP%20call%3F%26nbsp%3B%3C%2FP%3E%3CP%3EIFERROR()%26nbsp%3B%20has%20an%20%22else%22%20part%2C%20i.e%20the%202nd%20argument%20%2C%20typically%20you%20should%20be%20able%20to%20achive%20the%20results%20with%20your%20condition%20in%20this%20part.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
JCPeterson13
New 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
Highlighted

@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.     

 

Related Conversations
pull data based on dropdown list
bbombb in Excel on
1 Replies
Vlookup formula - partial text search
fredericomarquez in Excel on
2 Replies
URGENT Excel question HELP
RileyCDeason in Excel on
1 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies
Sum of Vlookup results
dleesBLX in Excel on
1 Replies