| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you copy a formula without incrementing some constants?
I have a formula that I want to copy across different worksheets in a
workbook but it keeps incrementing values that need to remain constant. The formula is as follows: =VLOOKUP(A95,Items!A2:B500,2,FALSE) And the part of the formula that I don't want to change is "A2:B500" (Items! being alpha remains as does "2,FALSE") I've tried using paste special but have not found the right combination. Is there a wilcard character that can be used? I've seen the use of $ but am not sure of the ramifications and where/when to use it. Currently, I'm having to manually edit each formula but there's got to be a better way! Thanks in advance for any help you can offer, -jt. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i copy formula? | Excel Worksheet Functions | |||
| how can i copy formula? | Setting up and Configuration of Excel | |||
| How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions | |||
| to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . | Excel Worksheet Functions | |||
| Copy a Formula down with a Twist Q | Excel Worksheet Functions | |||
Threaded Mode
