Not sure of your question. On the reference sheet, rows 7 through 13 are
copied and inserted. In the equation, those cells change from $A$7 to $A$14
(48's change to 55's) but I need them to stay the same. I am aware of the
indirect equation but can not seem to incorporate it into the index lookup
with the match. Thanks again.

"Sanjay" wrote:

where you add the row eg. after cell a or after cell b

"Kenton" wrote:

I need some help changing the following formula to reference the same cells
once the reference sheet is updated (additional rows are added). The formula
is as follows...

=INDEX('J:\KENTON\INTERMODAL\[DRAYMAN FUEL SURCHARGE
CHARTS.xls]COVER'!$K$7:$BB$48,MATCH(X25,'J:\KENTON\INTERMODAL \[DRAYMAN FUEL
SURCHARGE
CHARTS.xls]COVER'!$A$7:$A$48,0),MATCH(AH10,'J:\KENTON\INTERMO DAL\[DRAYMAN
FUEL SURCHARGE CHARTS.xls]COVER'!$K$6:$BB$6,0))

... and I need the following cells to stay the same when additional rows are
added to the reference sheet. $K$7:$BB$48 and $A$7:$A$48. Thanks.