I think you need only one INDIRECT, like this:

=-INDIRECT("'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$D$"&'C:\PCS
Connection\[Companyname.xls]Sheet1'!$A$1)


On Fri, 24 Sep 2004 22:52:48 -0500, samccune
wrote:


would i use this...

=-INDIRECT("'C:\PCS Connection\[Company
Discounts.xls]Sheet1'!$D$"&INDIRECT("'C:\PCS
Connection\[Companyname.xls]Sheet1'!$A$1))

to call the information from the discount sheet, but use the cell data
in A1 of the companyname document as the row number???