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?