Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pasting a formula without so much automation
=Lookup (a10,a7:a979,l7:.979) is the formula the problem is I have to cut and
paste this 300 times. I need the "a10" to change to "a11" I need "a7:a979" to remain I need "l7:l979" to change from and L to the next letter can you be of any help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pasting a formula without so much automation
Maybe you mean
=LOOKUP(A10,$A$7:$A$979,L$7:L$979) -- Kind regards, Niek Otten "Scott" wrote in message ... =Lookup (a10,a7:a979,l7:.979) is the formula the problem is I have to cut and paste this 300 times. I need the "a10" to change to "a11" I need "a7:a979" to remain I need "l7:l979" to change from and L to the next letter can you be of any help? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pasting a formula without so much automation
Are you looking to paste this down a column (e.g. autofill)? You should be
able to set up the references to handle it without any need to change the formula from cell to cell, although converting a change in rows to a change in columns is tricky. If I have it straight, try this: =Lookup($A10,$A$7:$A$979,OFFSET($L$7:$L$979,0,ROW( )-10)) The last part, the OFFSET, turns the row change into a change of columns, so for every row down your lookup results range will move one column to the right. So this cell if copied down the column below your original formula should change all the references in the way you specified - if that is indeed what you are trying to accomplish. -- - K Dales "Scott" wrote: =Lookup (a10,a7:a979,l7:.979) is the formula the problem is I have to cut and paste this 300 times. I need the "a10" to change to "a11" I need "a7:a979" to remain I need "l7:l979" to change from and L to the next letter can you be of any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula, automation turn red if value exceed a number | Excel Worksheet Functions | |||
Automation Macro for updating formula when changing cell value | Excel Discussion (Misc queries) | |||
Automation Macro for updating formula when changing cell value | Excel Discussion (Misc queries) | |||
Automation Formula almost complete | Excel Discussion (Misc queries) | |||
Excel automation - formula | Excel Programming |