Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Prevent Formulas from Advancing
Does anyone know how to prevent a formula from advancing when you copy it down. My situation is this, I'm trying to use the VLookup function to pull data from a table. When I copy the formula down, it doesn't just advance the lookup value number, it also advances the table array. I do want the lookup value to advance of course, but not the table array. I want the table array to be the same all the way down. For example, the formula looks like this: =VLOOKUP(B2,'September 2005'!A2:G296,1,FALSE) When I copy it down it changes to: =VLOOKUP(B3,'September 2005'!A3:G297,1,FALSE) and the numbers A3:G297 keep advancing as I copy the formula down. Like I said, I do want the B2 to advance to B3, but I do not want the A2:G296 to change when I copy the formula down. Is there a way to do this? -- dallased25 ------------------------------------------------------------------------ dallased25's Profile: http://www.excelforum.com/member.php...o&userid=28544 View this thread: http://www.excelforum.com/showthread...hreadid=482033 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |