Map a variable output to a mapping table

[ml8]

Hi

I am trying to work out whether I can map a variable value to a table to get a new value.

eg

1. In the front end I have an input box for a numeric variable 
2. in the back end I have a table which has 2 columns "values" and "words".
3. I want something to update in the front end reflecting the variable output

in excel I would do this

vlookup(Variable ("Values"),Table,2 ("Words"),0)

is this something that can be incorporated in the script, or can I do it in a measure?

[Ksrinivasan]

hi, 

good requirement,

ksrinivasan