Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Table array row number keeps increasing (2003)

    For some odd reason table array number keeps increasing, yet l want it to remain the same.
    I am baffled as to why this is?
    Any help would be appreciated, see screenshot
    Attached Images Attached Images

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Table array row number keeps increasing (2003)

    1) Highlight the cell I2
    2) Click into the formula and highlight B2, press F4 (Function 4) on your keyboard It will change to $B$2
    3) Repeat #2 but select C12

    By adding the $ marks you are now making the range absolute and will not change referentially

    4) Drag the formula down to where you want it using the cell toggle
    Jerry

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table array row number keeps increasing (2003)

    You need to make the reference absolute $C$11 instead of C11. Since you are using the VLOOKUP, your should make the enitre lookup range absolute: engineers!$B$:$C$11


    Excel "see" formula references as distance away from the referencing cell.
    For example:If you have the formula "=A1" in cell B2, Excel "sees" it as = one row up and one row to the left or =R[-1]C[-1] in R1C1 referencing (Tools / Options... general Tab to change the setting to this referencing method).

    When you drag the formula, it keeps the same reference.

  4. #4
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table array row number keeps increasing (2003)

    Much appreciated, many thanks

  5. #5
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table array row number keeps increasing (2003)

    That makes things clearer, thanks

Posting Permissions

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