Lookup in table, return a formula
Is there a way to lookup a name/value of a cell in a table and the resulting answer is a formula?
I am wanting to build a calculation, which could use 1 or more variables, depending on the value of a dropdown menu (Im assuming a drop down, since that would force the exact name/format of the formula callout).
Above is a quick and dirty example.
If in Cell8, there is a drop down that listed the values in column J (1 Face Area, Length Face Area, etc.).
In Cells D-F8, a user can input the thickness, length & width.
Cell H8 would lookup the value from C8, reference the table from J5:K11, and after finding the formula, it will do the appropriate calculation. What I listed as a formula is just text for the example. I am open to adjusting as needed.
This is just an example. I know I could do a bunch of imbedded IF statements in this example, but assume the table from J5:K11, could be many many lines. The table could be as many columns and rows as needed.
Further, the example is just a single line (row 8), the intent would be to have many (10's, 100's or even 1,000's) rows of data, so calculating the answers and looking those up the table wouldn't work, like a single line entry.
Is this even possible? I would prefer to accomplish this without VBA, if possible.
EDIT:
Here is another version of the example. As you can see I am planning on having multiple lines of entries. Some will have the same dropdown formula requested (i.e. Length Face Area), while others may never be requested. Hopefully that clarifies a bit.
Also, while I would prefer to do without VBA, if that is the "easiest" solution, I am not opposed to entertaining.
[link] [comments]
Want to read more?
Check out the full article on the original site