When you say:
<<<"I insert a column in column 1 through 3 in Sheet 1"
Exactly what columns are you talking about?

Do you mean inserting columns before or after Column A, B, or C, or do you
mean inserting columns between Columns T and X?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"surg4u1975" wrote
in message ...

--------------------------------------------------------------------------
------

I am using VLOOKUP to pull data from one sheet to another.

When I insert a column in the sheet referenced in the VLOOKUP formula
the formula is not auto updating. Is there a preference setting that I
have erroneously changed?

i.e. =VLOOKUP(A3,'Sheet1'!$T:$X,3,FALSE) and the 3 should change to a
4 if I insert a column in column 1 through 3 in Sheet 1.


--
surg4u1975
------------------------------------------------------------------------
surg4u1975's Profile:
http://www.excelforum.com/member.php...o&userid=28718
View this thread: http://www.excelforum.com/showthread...hreadid=484108