Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
increasing a cell value on each use | Excel Worksheet Functions | |||
Stopping a constant variable cell from being copied. | New Users to Excel | |||
increasing a cell by 1 | Excel Worksheet Functions | |||
Stopping the Fx Window from dropping down when clicking in a cell | Excel Discussion (Misc queries) | |||
Stopping free text entry in validation cell | Excel Discussion (Misc queries) |