Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
I have the following formula inserted into a cell. I know it works because
it returns the correct value. =VLOOKUP(K4,A3:C714,3,FALSE) I now need to copy this same formula in the same column over about 700 rows of data. The "K4" will obviously change since that's the value I'm looking for, but how do I lock the range table, i.e. "A3:C714", so it won't increase when I copy the formulas down? Also, is there something I need to do in Paste Special to make the formula work in the other rows? I've tried everything and I can't get the formula to copy correctly. I obviously don't want to retype it 700 times. Any help would be GREATLY appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |