+ Reply to Thread
Results 1 to 4 of 4

Fill down changing part, but not all of the formula

  1. #1
    Registered User
    Join Date
    10-12-2005
    Posts
    5

    Fill down changing part, but not all of the formula

    How can I get part of the formula to change as I fill down, but some of it not change. See my formula below, I want to fill down, and have the part "'Grecian Order Form'!D8" change to D9, D10, D11, etc as I fill down, but I want the rest of the formula to stay the same, help!

    =IF(D8=Prices!B4,Prices!C4,
    IF('Grecian Order Form'!D8=Prices!B5,Prices!C5,
    IF('Grecian Order Form'!D8=Prices!B6,Prices!C6,
    IF('Grecian Order Form'!D8=Prices!B7,Prices!C7,
    IF('Grecian Order Form'!D8=Prices!B8,Prices!C8,
    IF('Grecian Order Form'!D8=Prices!B9,Prices!C9,
    IF('Grecian Order Form'!D8=Prices!B10,Prices!C10,
    IF('Grecian Order Form'!D8=Prices!B11,Prices!C11,
    IF('Grecian Order Form'!D8=Prices!B12,Prices!C12,
    IF('Grecian Order Form'!D8=Prices!B13,Prices!C13,
    IF('Grecian Order Form'!D8=Prices!B14,Prices!C14,
    IF('Grecian Order Form'!D8=Prices!B15,Prices!C15,
    IF('Grecian Order Form'!D8=Prices!B16,Prices!C16,
    IF('Grecian Order Form'!D8=Prices!B17,Prices!C17,
    IF('Grecian Order Form'!D8=Prices!B18,Prices!C18,
    IF('Grecian Order Form'!D8=Prices!B19,Prices!C19,
    IF('Grecian Order Form'!D8=Prices!B20,Prices!C20,
    IF('Grecian Order Form'!D8=Prices!B21,Prices!C21,
    IF('Grecian Order Form'!D8=Prices!B22,Prices!C22,
    IF('Grecian Order Form'!D8=Prices!B23,Prices!C23,
    IF('Grecian Order Form'!D8=Prices!B24,Prices!C24,
    IF('Grecian Order Form'!D8=Prices!B25,Prices!C25,
    IF('Grecian Order Form'!D8=Prices!B26,Prices!C26,
    IF('Grecian Order Form'!D8=Prices!B27,Prices!C27,
    IF('Grecian Order Form'!D8=Prices!B28,Prices!C28,"")))))))))))))))))))))))))

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Fill down changing part, but not all of the formula

    Try this:

    Please Login or Register  to view this content.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    10-12-2005
    Posts
    5

    Re: Fill down changing part, but not all of the formula

    Awesome, only now i am getting "#N/A" for any unmatched value, how can i get it to have "" for an unmatched value?

  4. #4
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Fill down changing part, but not all of the formula

    Try this:

    Please Login or Register  to view this content.

+ 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