Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula question
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question - please help | Excel Worksheet Functions | |||
if formula question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Formula question | Excel Worksheet Functions |