INDIRECT formula construction

[frog]

My formula is working fine, and sits in cell B2:
<table x:str="" style="border-collapse: collapse; width: 422px; height: 36px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 206pt;" width="274"><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 206pt;" width="274" height="17">INDIRECT("[workbookalpha.xls]Template!B"&A1)</td> </tr></table>It is combining the variable number it finds in cell A1 with information in column B in a different workbook.

I would like to add something to this formula, and have not found the correct way to express it:

Cell A2 contains the unvarying text "workbookalpha", so (to save typing the same workbook names twice -there are many- running down columns A and B), I'd like to alter the portion of the above formula that references the workbook address in square brackets, to source the "workbookalpha" portion of the address from cell A2.

Thank you in advance for your help with this question!
frog

 

[Special-K99]

You mean like this (untested)

INDIRECT("["&A2&"]Template!B"&A1)

 

[frog]

Thank you 'K99,

So since the ".xls" portion of the workbook address is not in cell A2, but needs to be added to the INDIRECT formula to make it work, would the construction then be:

INDIRECT("["&A2&.xls"]Template!B"&A1)

or

INDIRECT("["&A2&".xls]Template!B"&A1)

or ...?

Thanks again!
frog

 

[Special-K99]

Yeah second one

INDIRECT("["&A2&".xls]Template!B"&A1)

 

[frog]

<frog dances around in joy>
Thank you so much 'K99! It works! This will save me so much time/typing and I was beating my head against the desk trying to make the equation work.
Thank you!!!

frog