"abraun" wrote in message
...
I am using the following fomula
=LOOKUP(c3,Lists!$aa2:$aa113,Lists!$ab2:ab113)
the formulas works great, however in trying to copy the formula, it adds a
number to the list values and looks like this.
=LOOKUP(c3,Lists!$aa3:$aa114,Lists!$ab3:ab114)
the list I am wanting to work with starts at aa1 and ends at aa113, so
this
will not work.
I do not want to edit the formula in each cell, as I am wanting to fill
acouple thousand cells.
any suggestions?


Edit the original formula to be
=LOOKUP(c3,Lists!$aa$2:$aa$113,Lists!$ab$2:ab$113)
See the extra $ signs?

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)