Dragging VLOOKUP

  • Thread starter Thread starter mohd21uk via OfficeKB.com
  • Start date Start date
M

mohd21uk via OfficeKB.com

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.
 
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

|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.aspx/excel-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.
 
Back
Top