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??

--
samccun
-----------------------------------------------------------------------
samccune's Profile: http://www.excelforum.com/member.php...fo&userid=1459
View this thread: http://www.excelforum.com/showthread.php?threadid=26340

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???