| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formulas across worksheets are not updating
-------------------------------------------------------------------------------- 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas Not Updating!!! | Excel Discussion (Misc queries) | |||
| Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
| Inserting Columns and Formulas updating | Excel Worksheet Functions | |||
| Copy worksheets with formulas between different workbooks | Excel Discussion (Misc queries) | |||
| Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
