Posted to microsoft.public.excel.worksheet.functions

Mary Lou[_2_] Mary Lou[_2_] is offline

external usenet poster

Posts: 21

Nested IF statement

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,F ALSE))),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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF Statement or nested IF	Rahim	Excel Worksheet Functions	4	October 5th 09 04:04 PM
Nested IF/OR/AND statement	Gayla	Excel Discussion (Misc queries)	0	June 20th 07 07:46 PM
Nested IF Statement	aposatsk	Excel Discussion (Misc queries)	1	August 1st 06 05:19 PM
Nested IF Statement	aposatsk	Excel Discussion (Misc queries)	1	August 1st 06 05:16 PM
7+ nested if statement?	Turi	Excel Worksheet Functions	3	December 20th 04 07:55 PM

All times are GMT +1. The time now is 04:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us