Hi,
Is there a way to use text from a cell as part of formula text in another cell?
For example:
in general, there is four sheets in the workbook (car, banana, apple and result).
Car, banana, and apple sheets have the same structure and data.
In the result sheet:
If A1 is a list and you can select "car!, banana!, apple!"
A2 is the "main formula". In this formula I would like to pick the sheet to be used from the list in A1, but use the rest of formula text as typed in the formula.
For example, in short: "=SUM(A1&B1:B100)". By changing the A1 results in different total. I have tried with CONCATENATE and & " " methods, but does not work. I also tried FORMULATEXT before CONCATENATE, but all these results in #VALUE!
Brg,
Thomas
Bookmarks