Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use formula result as the formula for another 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Bar F9 Result differs from cell result??? | Excel Worksheet Functions | |||
multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |