Hello, everybody. I am a fairly experienced Excel user, but not an expert. I have a spreadsheet that contains 32 numerical values (1-32). I also have 32 unique functions that are matched up to numerical values. What I am trying to come up with is a way to have a cell return the result of a function that is called based on the input value. I've attached an extremely simplified example of what I am trying to do. In the example spreadsheet, Column A represents my numerical values (limited to 5 for the example). Column B represents the unique formula that coincides with each numerical value. Cell C7 has a value of 7. Column D represents the input values. Note that they are not in numerical order. Column E represents the value that I hope to get back after Excel figures out that for an input value of 1, I want it to apply the formula in cell B3. I've come up with quite a few ways to get the text of the formula to return in the cells of Column E, but what I really want is a way to get the text of the formula with an actual equals sign so that the formula calculates the result. I'm not opposed to adding columns where multi-step operations are conducted. Obviously, I could handle 5 values from the example spreadsheet with an IF formula, but like I said, I've got 32 values and my formulas in my actual spreadsheet are more complex than in the simplified example. Thanks in advance for any help that comes in.
Bookmarks