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?
|