Thread: Coping formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
carper1975 carper1975 is offline
external usenet poster
 
Posts: 2
Default 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)