I have a Lookup table that looks like this:
And I am soliciting user input using a VizLib input form like this:
I would like to pass the input responses to individual variables, then search for data in the Lookup table using those variables. For example, if the user inputs a response of $5.00 for "10. What is the CHP Fuel price, in $/MMBtu?", then I would like to assign 5 to a variable vCHPFuelPrice, then cross-reference the Lookup table using vCHPFuelPrice in order to calculate a result.
How would I do this in Qlik Sense?