+ Reply to Thread
Results 1 to 6 of 6

Need a Nested IF with 12 Arguments

  1. #1
    Registered User
    Join Date
    02-07-2007
    Posts
    37

    Need a Nested IF with 12 Arguments

    Hi Can anyone help me with this please.

    I've been on it all morning and am stuck.

    This is my formula

    =IF($G$7=DATEVALUE("Apr-10"),Budget!$B2, IF($G$7=DATEVALUE("May-10"),Budget!$C2,

    and so on for 12 months...

    The problem is that when I hit 7, I am up to the limit for nested if statements.

    Any ideas, I cant figure out VLOOKUP

    I have found spliting the formula and giving the 2 parts defined name doesnt work as when I add them together again, I end up with only half the forumla working (as my lookup G7 will only be true on 1 half of the split formula.....

    Hope someone can help

    Thanks

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Need a Nested IF with 12 Arguments

    Can you post a workbook showing your data layout? You almost certainly do not need nested IFs (and if you do, you need to rethink the layout!)
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    02-07-2007
    Posts
    37

    Re: Need a Nested IF with 12 Arguments

    Please see next post
    Last edited by daz_uk; 03-29-2010 at 08:25 AM.

  4. #4
    Registered User
    Join Date
    02-07-2007
    Posts
    37

    Re: Need a Nested IF with 12 Arguments

    Hi,

    Workbook is attached.

    The formula I am having problems with is in G13 on the first workbook, I only has the formula for 3 months, I need this to work for 12, but as I have mentioned once I hit 7 I am up to the limit.

    Thanks in advance
    Attached Files Attached Files

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Need a Nested IF with 12 Arguments

    The formula you want is:
    =INDEX(Budget!$B2:$M2,MATCH($G$7,Budget!$B$1:$M$1,0))

    See attached.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-07-2007
    Posts
    37

    Re: Need a Nested IF with 12 Arguments

    wow - that is brilliant, thank you so much, I knew there must have been an easier way to do it...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1