| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying a formula
Hi,
I am trying to copy a formula like the one below from one cell to multiple cells. However, the cell ranges specified also change along with the lookup cells. Is there any shortcut to simply drag the formula with out having to correct each cell ? =D2*INDEX($A$9:$E$12,MATCH(C2,$A$9:$A$12,1),MATCH( B2,$A$9:$E$9,1)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a row using a formula | Excel Discussion (Misc queries) | |||
| copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| copying formula | Excel Worksheet Functions | |||
| copying a formula | Excel Discussion (Misc queries) | |||
![Sri Harsha[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
