Copying a formula

  • Thread starter Thread starter Sri Harsha
  • Start date Start date
S

Sri Harsha

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 said:
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))
Click to expand...

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?
 
Back
Top