Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to have a variable set to a certain value based on the value inputted into a input box
I have a table with two columns, and every value is unique
Letter | Number |
---|---|
A | 1 |
B | 2 |
C | 3 |
D | 4 |
How do i go about having a variable that will be set to "1" when "A" is entered into the input box
Thanks
Assume you've got variable vInput with value 'A':
=Only( {<Letter = {'$(vInput)'}>} Number)
edit: use this as definition of your other variable (Including the leading equal sign)