Hi all,
Sorry if the answer to this is somewhere else, but I can't find it anywhere, so as you can see, I created an account for myself to ask this question.
What I need to know is how to include another cell's text inside a formula. In my case, my main spreadsheet spreadsheet's first column contains country names (i.e., A1 is Australia, A2 is Austria, etc.). I also have multiple spreadsheets that I am referencing in formulas throughout my main spreadsheet, and those other referenced spreadsheets all have corresponding country names as titles. So, for example, one of the formulas in the Belgium row in my main spreadsheet is: =[Belgium.xls]Sheet1!$H$16
But I need a more general way of expressing the "Belgium" part so that I don't have to tediously enter every correct country's name in each formula in my main spreadsheet. Since the first cell in the row with the formula referenced above contains "Belgium", I tried substituting the formula above with the following: =["A3"&.xls]Sheet1!$H$16
This turned out to be a horrible failure. Any help on how to accurately fix my problem would be much appreciated. Thanks in advance.
Bookmarks