Option 1: use a defined name for the table (InsertNameDefine)

Option 2: Use absolute references instead of relative.

Not:

=VLOOKUP(C1,A1:B3,2,FALSE)

but

=VLOOKUP(C1,$A$1:$B$3,2,FALSE)

You can toggle between different variations of absolute and relative with the F4 key, when the cursor is on the reference in the
formula bar

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bobby6901" wrote in message ...
|I am trying to copy a VOOKUP formula down a column, and
| Excel wants to change the reference array as I move to lower rows. How do I
| stop that?