No it won't, if you want it to you need to refer to something that will also
increment, such as COLUMN(A1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"SamuelT" wrote in
message ...

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