"indirect" cell ref change....
 

Hi,

The last three digits (282) has to change to (283) when I change the
contents of cell L1 to 283 and so on. How can I do this ? I tried
"indirect" but am struggling with sytax.

='[Client Rate Sheet New.xls]PersTot'!$P$282

"indirect" cell ref change....
 

=INDIRECT("[MENU.xls]Sheet4!$A$"&F17&"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ORLANDO VAZQUEZ" wrote in
message ...
Hi,

The last three digits (282) has to change to (283) when I change the
contents of cell L1 to 283 and so on. How can I do this ? I tried
"indirect" but am struggling with sytax.

='[Client Rate Sheet New.xls]PersTot'!$P$282

"indirect" cell ref change....
 

Try it like this:

=INDIRECT("'[Client Rate Sheet New.xls]PersTot'!P"&L1)

Note that the referenced file *must* be open.

--
Biff
Microsoft Excel MVP


"ORLANDO VAZQUEZ" wrote in
message ...
Hi,

The last three digits (282) has to change to (283) when I change the
contents of cell L1 to 283 and so on. How can I do this ? I tried
"indirect" but am struggling with sytax.

='[Client Rate Sheet New.xls]PersTot'!$P$282