pasting a formula without so much automation

[Scott]

=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?

[Niek Otten]

Maybe you mean

=LOOKUP(A10,$A$7:$A$979,L$7:L$979)

--
Kind regards,

Niek Otten

"Scott" <[email protected]> wrote in message
news:[email protected]...
> =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?

[K Dales]

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?