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