Reference a cell based on another cell's cell reference

Question

Is there anything that acts like =CELL("contents",A2) except returns the formula from A2 instead of the contents from A2?

I want to use a formula from one cell to build a similar formula in another cell.

A2 currently contains the formula =Tests!B1

I want to build a new formula that strips out the B and uses another cells data in my Results worksheet to create a new formula that pulls related data from Tests.

Can you give a specific example of what you are trying to do with input and desired output? — SincereApathy, Feb 11 '16 at 23:57

score 2 · Accepted Answer · edited May 23 '17 at 11:59

2

What version of Excel? 2013+ has FormulaText(...)

https://support.office.com/en-us/Article/FORMULATEXT-function-0a786771-54fd-4ae2-96ee-09cda35439c8

If not, check out this question's answer.

edited May 23 '17 at 11:59

Community

1
1

answered Feb 11 '16 at 23:52

Mike

2,434
1
16
19

That's exactly what I was looking for. Thanks Mike. – Dave F Feb 12 '16 at 00:56

Reference a cell based on another cell's cell reference

1 Answers1