Copying Lookup formulas

I have a simple lookup formula

=LOOKUP(F8,O8:O29,P8:P29)*G8

Where I need to use the value of cell "F8" to determine what I must multiply
"G8" by. Works fine. I need to know how to drag that formula (copy) it to
successive cells. When I do that, Excel advances all the values by one
number e.g. =LOOKUP(F9,O9:O30,P9:P30)*G9. This gives me an incorrect
result. How can I make it advance the cells without advancing the lookup
range? I did a search on Lookup and received a ton of hits, thought I could
narrow it down with a direct question.

TIA

Randy,

Use a $ before the cell references you need to be absolute. eg $F$8 or $F8
or f£8 for absolute cell, column or row respectively. The character preceded
by $ will not change when copying the formula.

Ian
"Randy Vieira" <[email protected]> wrote in message
news:[email protected]...
>I have a simple lookup formula
>
> =LOOKUP(F8,O8:O29,P8:P29)*G8
>
> Where I need to use the value of cell "F8" to determine what I must
> multiply "G8" by. Works fine. I need to know how to drag that formula
> (copy) it to successive cells. When I do that, Excel advances all the
> values by one number e.g. =LOOKUP(F9,O9:O30,P9:P30)*G9. This gives me an
> incorrect result. How can I make it advance the cells without advancing
> the lookup range? I did a search on Lookup and received a ton of hits,
> thought I could narrow it down with a direct question.
>
> TIA
>
> Randy,
>

BINGO! Thanks A Bunch!

Randy,


"IC" <[email protected]> wrote in message
news:[email protected]...
> Use a $ before the cell references you need to be absolute. eg $F$8 or $F8
> or f£8 for absolute cell, column or row respectively. The character
> preceded by $ will not change when copying the formula.
>
> Ian
> "Randy Vieira" <[email protected]> wrote in message
> news:[email protected]...
>>I have a simple lookup formula
>>
>> =LOOKUP(F8,O8:O29,P8:P29)*G8
>>
>> Where I need to use the value of cell "F8" to determine what I must
>> multiply "G8" by. Works fine. I need to know how to drag that formula
>> (copy) it to successive cells. When I do that, Excel advances all the
>> values by one number e.g. =LOOKUP(F9,O9:O30,P9:P30)*G9. This gives me an
>> incorrect result. How can I make it advance the cells without advancing
>> the lookup range? I did a search on Lookup and received a ton of hits,
>> thought I could narrow it down with a direct question.
>>
>> TIA
>>
>> Randy,
>>
>
>