Coping formulas

[carper1975]

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

 

[Gordon]

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

 

[RagDyer]

Try this:

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