Choosing associated value based on selection?

[#1]

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

[swuehl]

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)