| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
locking part of look up formula
I am using a simple table from another sheet to look up a value that is part
of a formula. The formula is as follows: =VLOOKUP(Sheet1!AV3,Sheet3!A1:B4,2,FALSE)*T3 I have 500 data lines in which to input the formula so I want to copy it rather than type it 500 times. When I copy the formula, the copied formula looks like this: =VLOOKUP(Sheet1!AV4,Sheet3!A2:B5,2,FALSE)*T4 and I want it to look like this: =VLOOKUP(Sheet1!AV4,Sheet3!A1:B4,2,FALSE)*T4. The difference is that when copied the formula changes all of the values and I do not want to change the A1:B4 value. Is there a way to "lock" that portion of the formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
locking part of look up formula
$A$1:$A$B4
-- HTH... Jim Thomlinson "Gil" wrote: I am using a simple table from another sheet to look up a value that is part of a formula. The formula is as follows: =VLOOKUP(Sheet1!AV3,Sheet3!A1:B4,2,FALSE)*T3 I have 500 data lines in which to input the formula so I want to copy it rather than type it 500 times. When I copy the formula, the copied formula looks like this: =VLOOKUP(Sheet1!AV4,Sheet3!A2:B5,2,FALSE)*T4 and I want it to look like this: =VLOOKUP(Sheet1!AV4,Sheet3!A1:B4,2,FALSE)*T4. The difference is that when copied the formula changes all of the values and I do not want to change the A1:B4 value. Is there a way to "lock" that portion of the formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
locking part of look up formula
Thank you Jim. You saved me and my research assistant a lot of work.
Hooray!!!!! "Jim Thomlinson" wrote: $A$1:$A$B4 -- HTH... Jim Thomlinson "Gil" wrote: I am using a simple table from another sheet to look up a value that is part of a formula. The formula is as follows: =VLOOKUP(Sheet1!AV3,Sheet3!A1:B4,2,FALSE)*T3 I have 500 data lines in which to input the formula so I want to copy it rather than type it 500 times. When I copy the formula, the copied formula looks like this: =VLOOKUP(Sheet1!AV4,Sheet3!A2:B5,2,FALSE)*T4 and I want it to look like this: =VLOOKUP(Sheet1!AV4,Sheet3!A1:B4,2,FALSE)*T4. The difference is that when copied the formula changes all of the values and I do not want to change the A1:B4 value. Is there a way to "lock" that portion of the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula locking? | Excel Discussion (Misc queries) | |||
| Formula locking | Excel Worksheet Functions | |||
| Locking Part of a Worksheet/Tab | Excel Discussion (Misc queries) | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| locking a formula to cells | Excel Discussion (Misc queries) | |||
Linear Mode
