Coping formulas
 

=LOOKUP(W3,AT3:AX3,AT5:AX5) How do I copy this formula down cells below with
out the Look up vector and result vector changing down cells also. I only
need the lookup value to change as it copies down the cells example:
=LOOKUP(W4,AT3:AX3,AT5:AX5), =LOOKUP(W5,AT3:AX3,AT5:AX5)

Coping formulas
 

"carper1975" wrote in message
...
=LOOKUP(W3,AT3:AX3,AT5:AX5) How do I copy this formula down cells below
with
out the Look up vector and result vector changing down cells also. I only
need the lookup value to change as it copies down the cells example:
=LOOKUP(W4,AT3:AX3,AT5:AX5), =LOOKUP(W5,AT3:AX3,AT5:AX5)

Use absolute references:
IE change your formula to this:
=LOOKUP($W3,$A$T3:$AX$3,$AT$5:$AX$5)
Notice the lack of the "$" before the number in the first cell reference.

Coping formulas
 

Try this:

=LOOKUP(W3,AT$3:AX$5)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"carper1975" wrote in message
...
=LOOKUP(W3,AT3:AX3,AT5:AX5) How do I copy this formula down cells below
with
out the Look up vector and result vector changing down cells also. I only
need the lookup value to change as it copies down the cells example:
=LOOKUP(W4,AT3:AX3,AT5:AX5), =LOOKUP(W5,AT3:AX3,AT5:AX5)