Reply to thread

Message: [QUOTE="glenn.mettler.ctr, post: 14187247"] OK - I didn't express properly - I tried to use an abreviated set. Here isthe actual: in the formula bar when I use mouse to select between open workbooks: ='C:\Users\mettlerg\Desktop\eMRBM\RTP\Dec\[merge 12_11_12.arp Calc to -ML9822D8899 eMRBM 1 & 2 Ship to FSA.xls]Planner_Summary'!AS8 this renders the correct value in E4 In A1 I have: 'C:\Users\mettlerg\Desktop\eMRBM\RTP\ (the basic path) in A4 I have Dec (the month) In B4 I have [merge 12_11_12.arp Calc to - ML9822D8899 eMRBM 1 & 2 Ship to FSA.xls] (the file name) In C4 I have Planner_Summary' (the workbook tab name) I want a formula that I can concatenate that will give the correct value when I enter the file name and month (I only need to change the cell reference - !AS9, !AS10, !AS11 etc.) when I do this, the formula looks like: =A1&A4&B4&C4!AS8 what I get is: =A1&A4&B4&C4!AS8 instead of the value if I use Indirect() as suggested, I get: =A1&A4&INDIRECT(B4)&C4&!AS8 no errors but no values either there must be a way to do this regards, Glen [/QUOTE]