Thread: stopping value(from cell) from increasing when vlookup copied down
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PBcorn PBcorn is offline
external usenet poster
  
Posts: 79
Default stopping value(from cell) from increasing when vlookup copied down
I have the following formula:

=VLOOKUP(F1,'[Source Table.xls]Policies'!$A$4:$U$28,B9+1,FALSE)

the value of F1 is a month which must be constant (but can be changed for
each month if you see what i mean)

how can i make the formula treat F1 as constant when it is copied down?
Reply With QuoteReply With Quote