"indirect" cell ref change....

  • Thread starter Thread starter ORLANDO VAZQUEZ
  • Start date Start date
O

ORLANDO VAZQUEZ

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
 
Try it like this:

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

Note that the referenced file *must* be open.
 
Back
Top