Coping formulas

  • Thread starter Thread starter carper1975
  • Start date Start date
C

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)
 
carper1975 said:
=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)
Click to expand...

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.
 
Back
Top