HELP, dont know how to describe this in a subject line

[samccune]

would i use this...

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

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

 

[Myrna Larson]

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)