I do not want to concatenate a string or show the value like
"Some Text " & C12. I need to use the text in a cell as part of the formula in another cell. For Example:
I have a cell containing a date
17.02.2014. I need to use that date in a formula within another cell:
However this date needs to be pulled dynamically, for this example from
E26. I would have expected it to look something like:
What is the correct syntax?