Select which formula to use in a cell.
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. |
Select which formula to use in a cell.
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". |
Select which formula to use in a cell.
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". |
All times are GMT +1. The time now is 03:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com