Smart questions
Smart answers
Smart people
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 now!
  • 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.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

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 !!

TeknikalJock (MIS)
22 Mar 01 12:48
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?
JVFriederick (IS/IT--Management)
22 Mar 01 13:08
Edit the formula to :
VLOOKUP(H5,$A$2:$B$800,2,FALSE)

This will "freeze" the source table
TeknikalJock (MIS)
23 Mar 01 15:34
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