if you're =vlookup() formula looks like:

=vlookup(a1,sheet2!a1:b9,2,false)
you could use
=vlookup(a1,sheet2!$a$1:$b$9,2,false)
so that $a$1:$b$9 range won't change if you copy/move that formula.

But you could also do something like:
=vlookup(a1,sheet2!a:b,2,false)
(if there's nothing under that table that would bother the =vlookup() formula)


BROCK8292 wrote:

WHEN I COPY A VLOOKUP FORMULA THE CELL RANGE IS AUTOMATICALLY ADJUSTED. IS
THERE A WAY TO USE VLOOKUP WITH AN ENTIRE WORKSHEET AS THE RANGE THAT I WANT
IT TO SEARCH AS OPPOSED TO REFERENCING A SERIES OF INDIVIDUAL CELLS?

--

Dave Peterson