Text Box Formulas

Copper Contributor

Would it be possible to have text boxes that include formulas other than just a cell reference? I would like to be able to use XLookup in a text box.


2 Replies


No, that is not possible. Formulas only work in worksheet cells.

You could place the formula you need in a cell and place a reference to that cell in the text box.

The cell can be in another sheet, even a hidden one if you prefer.

Thanks!!! I was hoping this would be a feature that could be added to Excel.