I want to programatically set the formula in cell B based on the contents of cell A.
example below shows the following.
A1:C3 - matrix that can contain red/amber/green, yes/no, or Low/Med/High
L1:M3 - Numeric based value based on
a. Letter in Cell
b. an enumerated set of values
A B C L M N
1 R A G 1 2 3
2 Y N Y 1 0 1
3 L M H 1 2 3
I want to configure the formulas in L1:N3 programatically so the user never has to set these.