Forum Discussion
Lookup help with 2 or more variables
I am trying to create sort of a calculator where the user will choose 3 variables form dropdowns to return a price. The chart below is the information that they would provide and the result they should receive. For example, they would choose Trina, 22 panels, and cash and the result would be $3.10. Can someone assist with how to write this formula?
1 Reply
I would like to transformer the data structure to a long list before query.
maybe like:
trina 20 cash 3.25
trina 20 SAC 3.62
