Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing Cells | Excel Worksheet Functions | |||
Referencing Cells | Excel Worksheet Functions | |||
Referencing other cells | Excel Discussion (Misc queries) | |||
Referencing cells | New Users to Excel | |||
Referencing Cells | Excel Worksheet Functions |