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