Hi

You need to use absolute references for your range using $ signs eg:
=VLOOKUP(A2,$B$2:$C$50,2,FALSE)

Hope this helps.
Andy.

"mohd21uk via OfficeKB.com" <u20517@uwe wrote in message
news:606d8adf5bba1@uwe...
I have a apreadsheet with numeric values in Column E. These numeric values
are matchted with descriptions in sheet 2, where unique numeriv values are
in
COLUMN A and their description in Column B. I would like to use the
VLOOKUP
option to lookup the appropriate description in sheet 2 and return in to
sheet 1. When I use the VLOOKUP syntax the range is incremented leaving me
with errors. Is there any way I cn drage the values down the column
without
having the range changed.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200605/1