VLOOKUP table array does not stay put !!

[TeknikalJock]

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]

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

This will "freeze" the source table

 

[TeknikalJock]

PERFECT !!!

Thanks