I am aware of the indirect formula but I am having trouble incorporating it
into the index formula. Thanks though.

"galimi" wrote:

Kenton,

You can use the indirect formula to indicate a range that will never change,
even when the rows or columns shift.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"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.