Use formula result as the formula for another cell.

I

InsomniacFolder

Hello.
I Have successfully used:
=OFFSET(LookUp!$B$1,MATCH(Data!N6,CodeSelect,0),1,1,1)
to select the correct value from a range of 20 possible "formulas".

My problem is that the value I have is to be used as the formula in the
resultant cell.
i.e. my result is =LOWER(A6&"."&B6&E6)

How do I get that value to enter in to the resultant cell as an operating
formula?

I'm sure I have been able to do this in the past using INDIRECT but I can't
make it work now, the result remains as text, no matter how I format the
cells, or reference the result.

Any help is greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select which formula to use in a cell. 2
Indirect formula errors if file is closed 0
Counting Results of Formulas 1
Copy the content of a cell with Formula 1
Match function: error due to format? 4
formula displays as a formula, not as its result 1
match formula 2
Using formula to convert date result to text 3

Top