formula with text concatenation

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


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


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 *