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.

InsomniacFolder wrote:
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.





Look he

http://www.ozgrid.com/News/excel-eva...ormula-VBA.htm

under "Excel Tips and Tricks".

Thanks for this help, The ozgrid EVALUATE 4.0 Dialog functionallity does
work, to do exactly what I want.
There is however a compatibillity issue with saving to 2007 versions.
I have worked around the problem using 14(!) helper columns.

Thanks for your help, and apologies for not responding sooner.

"Glenn" wrote:

InsomniacFolder wrote:
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.





Look he

http://www.ozgrid.com/News/excel-eva...ormula-VBA.htm

under "Excel Tips and Tricks".