Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can achieve it using set analysis
Only({< Code = {'$(vCode)'}>} [Code Name])
You can achieve it using set analysis
Only({< Code = {'$(vCode)'}>} [Code Name])
Works great. Thank you very much!