View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kenton Kenton is offline
external usenet poster
 
Posts: 9
Default Referencing the same cells

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.