stopping value(from cell) from increasing when vlookup copied down

  • Thread starter Thread starter PBcorn
  • Start date Start date
P

PBcorn

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?
 
Enter F1 in the formula as an absolute reference:

Enter $F$1 when you type the function, or after type F1 press the F4 key to
create an absolute reference.

or if the formula has already been entered:

Highlight the F1 cell address in either the cell itself or the formula bar
and press the F4 key.
 
Back
Top