INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

VLOOKUP table array does not stay put !!

Share

VLOOKUP table array does not stay put !!

VLOOKUP table array does not stay put !!

(OP)
I have this problem with a VLOOKUP table that I have setup in excel. It works beautifully, however when I try to copy/paste the formula into another cell, it likes to move the start and finish points of the table array down as many spaces as I am going down when pasting. I know there should be a way to change the table array to be a fixed table array, I just cannot find out how.

Here is an example of my Vlookup, where A2:B800 is the table array.

=VLOOKUP(H5,A2:B800,2,FALSE)

example: if I copy this cell and paste into the cell below, I get the following..

=VLOOKUP(H6,A3:B801,2,FALSE)

Can anyone tell me how to change this to make the table array fixed, so I can paste into cells and have it not change?

RE: VLOOKUP table array does not stay put !!

Edit the formula to :
VLOOKUP(H5,$A$2:$B$800,2,FALSE)

This will "freeze" the source table

RE: VLOOKUP table array does not stay put !!

(OP)
PERFECT !!!  

Thanks

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close