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?

stopping value(from cell) from increasing when vlookup 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.
--
Kevin Backmann


"PBcorn" wrote:

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?