software

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
www.officekb.com/Uwe/Forums.a...l-new/200605/1

Best way is to use a defined Name for your range (Insertgt;Namegt;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

quot;mohd21uk via OfficeKB.comquot; lt;u20517@uwegt; 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
| 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.

quot;mohd21uk via OfficeKB.comquot; lt;u20517@uwegt; wrote in message
news:606d8adf5bba1@uwe...
gt;I have a apreadsheet with numeric values in Column E. These numeric values
gt; are matchted with descriptions in sheet 2, where unique numeriv values are
gt; in
gt; COLUMN A and their description in Column B. I would like to use the
gt; VLOOKUP
gt; option to lookup the appropriate description in sheet 2 and return in to
gt; sheet 1. When I use the VLOOKUP syntax the range is incremented leaving me
gt; with errors. Is there any way I cn drage the values down the column
gt; without
gt; having the range changed.
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...l-new/200605/1