formula with text concatenation

I can use the following formula to get a cell value from another excel workbook

=’N:GroupNYcurrent[tradingbook.xlsm]summary’!$P$10

Now I try to use the following equation to get the same value 

=”‘N:GroupNYcurrent[“&A1&”.xlsm]summary’!$P$10″

where A1 is the cell that contains text tradingbook.

Unfortuanately this does not work. I have also tried double quotations and so on, all does not work.

Plz help!

By: qingze

Leave a Reply

Your email address will not be published. Required fields are marked *