Using a variable input field value to return the corresponding value of another field

[zach_paz]

HI!

I've searched the forums to solve this question, but cannot seem to get it working. Your help is much appreciated!

I have two fields with the following values:

Code	Code Name
1	Car
2	Bus
3	Plane

I would like to use an input field value to designate the code. In this case, the variable is called "vCode". I would like to return the corresponding field value for what matches the "vCode" input field box.

Input Field Value: "vCode"= 2

Result:  Text Box: Bus

This would be similar to a vlookup in excel.

Thanks in advance!

Zach

[Vegar · Accepted solution]

You can achieve it using set analysis 

Only({< Code = {'$(vCode)'}>} [Code Name])

[zach_paz]

Works great. Thank you very much!

[taml]

Thanks @Vegar  for the solution and @zach_paz  for pitching a perfect question.