| 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? |
| 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) | |||
Threaded Mode
