Choosing associated value based on selection?

Mon, 26 Jan 2026 18:19:17 GMT

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

How do i go about having a variable that will be set to "1" when "A" is entered into the input box

Thanks

Re: Choosing associated value based on selection?

swuehl — Thu, 14 Sep 2017 20:39:09 GMT

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)