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))

If I understand you correctly, simply place an apostrophe in front of the
formula. This changes the formula to simple text. Copy the formula.
Remove the apostrophe from each destination cell.
Another way is to add a dollar sign in front of the column and row
references in the formula. Most of the cell references in your formula
already have that. HTH Otto
"Sri Harsha" wrote in message
...
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))

Sri Harsha wrote:
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))


What cell is this formula in?

What cell do you want the copy to be in?

What do you want the copy to look like?