Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Vlookup-copying formula down whole column

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I set up my vlookup table and it reports back to the cell the proper reference. But when I copy the vlookup statement down the rest of the spreadsheet column, it displaces the vlookup table, one cell downward each time. How can I hold the table reference steady, while I do down my column? (Does that make any sense?). Thanks.
    D

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hiya,

    Use Non-Relative references

    Instead of =Vlookup(A2,X2:Y200,2,false) use
    =Vlookup(A2,$X$2:$Y$200,2,false)

    Adam

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,593
    Post Thanks / Like
    Mentioned
    31 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-15 13:32, Dabulughod wrote:
    I set up my vlookup table and it reports back to the cell the proper reference. But when I copy the vlookup statement down the rest of the spreadsheet column, it displaces the vlookup table, one cell downward each time. How can I hold the table reference steady, while I do down my column? (Does that make any sense?). Thanks.
    D
    Just freeze the range that houses your table with a few $$ like in:

    =VLOOKUP(A1,$E$2:$G$20,2)

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Manchester UK
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-15 13:32, Dabulughod wrote:
    I set up my vlookup table and it reports back to the cell the proper reference. But when I copy the vlookup statement down the rest of the spreadsheet column, it displaces the vlookup table, one cell downward each time. How can I hold the table reference steady, while I do down my column? (Does that make any sense?). Thanks.
    D
    Try using the locked cell reference e.g.
    =VLOOKUP(H7,$I$7:$J$9,2,FALSE)
    instead of the ordinary
    =VLOOKUP(H7,I7:J9,2,FALSE)

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You all are great! Thanks so much!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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