HELP, dont know how to describe this in a subject line
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 |
HELP, dont know how to describe this in a subject line
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??? |
All times are GMT +1. The time now is 08:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com