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

Best way is to use a defined Name for your range (Insert>Name>Define)
You can also use F4 when editing your formula to toggle the reference under the cursor from relative to absolute:

A1 is relative, $A$1 is absolute, $A1 and A$1 are mixed.

--
Kind regards,

Niek Otten

"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

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