Hello all,
I have researched and found similar questions, but all the results are based on only a few options. I am looking for a solution with potentially unlimited options (okay, not really unlimited, but the list could become rather lengthy). I know I could use a string of embedded IFs, however I am then locked into the formulas defined in the IFs and any updated would have to be extended to multiple rows of formulas.
I have attached a quick and dirty example file.
In short, I will have a line with some user defined attributes (in the example, it will be thickness, length, and width). Then using these attributes, based on the value that is input into column E (in the attached I used a dropdown to force the name), the result in column F would be calculated. I don't have to use a dropdown menu, but thought it would be cleaner and easier to force the exact text needed assuming a lookup formula is used. In the example, I used typical formulas that everyone is familiar with, and then threw in a random length^2 and width^2 to spice it up. The future formulas/calculations could range in complexity of simply addition of two attributes to complex calculation. Future calculations may also be based on more than just the three attributes shown.
My thought was the solution to this problem would be in the green cells, and then copied down what could be dozens or hundreds of rows. The bordered list would also hopefully be expandable. I hope I have explained my problem, and what I am hoping to achieve. I guess part of my requested solution is to also describe how to "adjust" the formulas currently in column K, so if any change is needed in the future, they can be easily updated, and then filter throughout the sheet.
Lastly, I would like to achieve this without VBA if possible, but if necessary, well then it is necessary.
As always, any help is appreciated, and if any additional info is needed, don't hesitate to ask. I hope I didn't ramble too much. This forum has been fantastic at helping me in the past (even when I don't specifically ask the question).
Bookmarks