View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SamuelT
 
Posts: n/a
Default Dragging VLOOKUP


Hi all,

I'm using a VLOOKUP formula (in Excel 2000) and need to drag the
command across a range of columns. Weird thing is (and I'm sure it
never used to do this), the column number - i.e. =VLOOKUP(whatever
,whatever, THIS NUMBER, false) doesn't change when I do the dragging.
One would think that it would go up incrementally..

Have I disabled some option, or is there a means of doing this?

TIA,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=551449