I am trying to do a nested if statement with VLookup function. Here is an
example:
=IF(C156="NJ",(VLOOKUP($A156,Nigel!$A$10:$S$24,8,FALSE))),IF(C156="JAM",(VLOOKUP($A156,JAM!$A$10:$S$24,8,FALSE)))
Not sure what i am doing wrong. the first statement works (Nigel). for the
second one i get #VALUE
can someone help me? thanks
|
|
0
|
|
|
|
Reply
|
 Utf
|
2/25/2010 4:58:08 PM |
|
You have too many unnecessay ( ).
=IF(C156="NJ",VLOOKUP($A156,Nigel!$A$10:$S$24,8,0),IF(C156="JAM",VLOOKUP($A156,Jam!$A$10:$S$24,8,0),""))
--
Biff
Microsoft Excel MVP
"Mary Lou" <MaryLou@discussions.microsoft.com> wrote in message
news:8BC2B046-6083-4A18-9170-3B648B6CF3B8@microsoft.com...
>I am trying to do a nested if statement with VLookup function. Here is an
> example:
>
> =IF(C156="NJ",(VLOOKUP($A156,Nigel!$A$10:$S$24,8,FALSE))),IF(C156="JAM",(VLOOKUP($A156,JAM!$A$10:$S$24,8,FALSE)))
>
> Not sure what i am doing wrong. the first statement works (Nigel). for
> the
> second one i get #VALUE
>
> can someone help me? thanks
|
|
|
0
|
|
|
|
Reply
|
T
|
2/25/2010 5:09:47 PM
|
|
Mary Lou wrote:
> I am trying to do a nested if statement with VLookup function. Here is an
> example:
>
> =IF(C156="NJ",(VLOOKUP($A156,Nigel!$A$10:$S$24,8,FALSE))),IF(C156="JAM",(VLOOKUP($A156,JAM!$A$10:$S$24,8,FALSE)))
>
> Not sure what i am doing wrong. the first statement works (Nigel). for the
> second one i get #VALUE
>
> can someone help me? thanks
Try this:
=IF(C156="NJ",VLOOKUP($A156,Nigel!$A$10:$S$24,8,FALSE),IF(C156="JAM",VLOOKUP($A156,JAM!$A$10:$S$24,8,FALSE)))
|
|
|
0
|
|
|
|
Reply
|
Glenn
|
2/25/2010 5:14:21 PM
|
|
THANK YOU - PERFECT!!!
"Glenn" wrote:
> Mary Lou wrote:
> > I am trying to do a nested if statement with VLookup function. Here is an
> > example:
> >
> > =IF(C156="NJ",(VLOOKUP($A156,Nigel!$A$10:$S$24,8,FALSE))),IF(C156="JAM",(VLOOKUP($A156,JAM!$A$10:$S$24,8,FALSE)))
> >
> > Not sure what i am doing wrong. the first statement works (Nigel). for the
> > second one i get #VALUE
> >
> > can someone help me? thanks
>
>
> Try this:
>
> =IF(C156="NJ",VLOOKUP($A156,Nigel!$A$10:$S$24,8,FALSE),IF(C156="JAM",VLOOKUP($A156,JAM!$A$10:$S$24,8,FALSE)))
> .
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
2/25/2010 7:54:01 PM
|
|
You're welcome!
Mary Lou wrote:
> THANK YOU - PERFECT!!!
>
> "Glenn" wrote:
>
>> Mary Lou wrote:
>>> I am trying to do a nested if statement with VLookup function. Here is an
>>> example:
>>>
>>> =IF(C156="NJ",(VLOOKUP($A156,Nigel!$A$10:$S$24,8,FALSE))),IF(C156="JAM",(VLOOKUP($A156,JAM!$A$10:$S$24,8,FALSE)))
>>>
>>> Not sure what i am doing wrong. the first statement works (Nigel). for the
>>> second one i get #VALUE
>>>
>>> can someone help me? thanks
>>
>> Try this:
>>
>> =IF(C156="NJ",VLOOKUP($A156,Nigel!$A$10:$S$24,8,FALSE),IF(C156="JAM",VLOOKUP($A156,JAM!$A$10:$S$24,8,FALSE)))
>> .
>>
|
|
|
0
|
|
|
|
Reply
|
Glenn
|
2/25/2010 9:03:28 PM
|
|
|
4 Replies
401 Views
(page loaded in 0.107 seconds)
Similiar Articles: Nested IF(OR(AND) Statement with Two AND Conditions - microsoft ...I am using Excel 2003 and could use some assistance with a complex Nested IF statement. Here is the criteria: IF Salesorg=NAW1 AND Salesdivision=... Nested IIF Statement in a query - microsoft.public.access.queries ...I'm trying to set up a nested IIF statement in a query and I'm striking out. Basically I'm trying to do the following: If "Field A" and "Field B... Nested Ifs VBA, How to - microsoft.public.excel.programming ...Hello, Would anyone show me how to put the ifs statements below in VBA. I would like the results to show in column AQ: IF(AND(U2>0,V2=0),"ORF "... Nested "IIF" or....? - microsoft.public.access.reports ...Criteria 1 has been chosen ie 98 - 102 and the Characteristic Value = 101.3 PassFail should say "Pass" Should this be done using nested IIF statements, or is there an ... Nesting IF Statement in excel 2007 - microsoft.public.excel ...Nesting IF Statement in excel 2007 - microsoft.public.excel ... Nested If Formula - microsoft.public.excel.misc Nesting IF Statement in excel 2007 - microsoft.public ... Nested If Formula - microsoft.public.excel.miscI have tried several different variations of Nested IF statements, but to no avail. I do not know VBA, so ... Nested IFs Suppose we wanted an nested IF formula to test: IF ... Nested IF & AND functions - microsoft.public.excel.worksheet ...Nested IF(OR(AND) Statement with Two AND Conditions - microsoft ... I am using Excel 2003 and could use some assistance with a complex Nested IF statement. Excel 2003 - Nested IF functions, VLOOKUP, or something else ...Nested IF(OR(AND) Statement with Two AND Conditions - microsoft ... I am using Excel 2003 and could use some assistance with a complex Nested IF statement. ... in cell E2 ... Testing for an Integer result in a formula - microsoft.public ...I'm writing a nested IF statement in which one step needs to test the value of one cell divided by another cell, and determine if it is an integer b... joining two iif statements - microsoft.public.access.queries ...What do I need: multiple nested IIF? Switch()? DateDiff ... joining two iif statements - microsoft.public.access.queries ... What do I need: multiple nested IIF? Nested IF Statements and Formula - Linda's Computer Stop Ebooks ...How to use the IF function in Microsoft Excel ... FROM WILEY: Download sample Excel files to accompany the book. Instructors may download tests, slides, outlines ... How to use nested IF statements in Excel with AND, OR, NOT ...Following up on last week’s introductory post on using the IF function, here’s one on how to use Excel’s IF statement when you have multiple conditions to meet. MS Excel: Nested IF Functions - TechOnTheNet.comIt is possible to nest multiple IF functions within one Excel formula. You can nest up to 7 IF functions to create a complex IF THEN ELSE statement. Nesting/Nested if statementsNesting if statements. Situations arise when you have to use nested IF structure. Nested structures simply contain other IF structures. You can easily nest IF ... Nested IF Statements - - Microvellum - Woodworking Software Solutions"Nested" IF Statements. At times you may find it necessary to use multiple or "Nested" IF statements in a formula. We know that the syntax for an IF statement is: 7/25/2012 11:34:47 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 