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