Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Incrementing column value in VLOOKUP (Excel 2000 SR-1)

    Try using the Column() function. This function without arguments returns the column number th eformula is located in. You could adjust the value with -x (or +x) to meet your needs.

    For example if your VLOOKUP function id in column H and you want to return the value from the second column of a look-up table, you could use

    =VLOOKUP($G2,Table,Column()-6,False)

    assuming the search value is in G2. (Column H is the eight column so subtract 6). If you drag that formula to column I, you should get a value from the third column in the look-up table.

    Andrew C

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Incrementing column value in VLOOKUP (Excel 2000 SR-1)

    Another way is to list the column nos as "headers"
    <pre>=VLOOKUP($G2,Table,a$1,False)
    </pre>


    When this is copied it is locked on column G and row1 for its inputs. This should mean that ALL the formulas are identical, though as you move across columns and down rows, other data is obtained.

    Steve

  3. #3
    New Lounger
    Join Date
    Dec 2002
    Location
    Port Elizabeth, South Africa
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Incrementing column value in VLOOKUP Thanks Folks!

    <P ID="edit" class=small>(Edited by oldestteenager on 06-Dec-02 05:57. Solved Many Thanks)</P>Is there anyway to increment the column index number argument in the VLOOKUP function when copying columns other than manually editing each argument that has been copied.

Posting Permissions

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