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