I need to be able to call a formula based on the account name that gets entered into a cell. I have the list of formulas created as text (no equal sign at the beginning) named as formulas and I thought the Indirect function would work to call the text and then execute it as a formula, but it only displayed the text for the formula. I need to calculate the cost based on data in other cells, but won't know which formula to apply until the account name is entered. The cells I need to reference stay the same, but cost rate I apply varies by account. How can I dynamically choose the correct formula that then executes when called instead of executing in the list of formulas? I'm familiar with VLOOKUP and Data Validation, but can't figure out how to do this. An example of the formula I'm using is this M6*(H6*.3+I6+X) where the ".3" will vary and the "X" will vary, but the cell references stay the same. Any thoughts?
I have attached a workbook that contains three possible answers to your question. And there are probably more ways to achieve the same. Not sure, though, how your schedule looks like and which solution suits you best.