Is it possible to look up a value based on a value entered in a field - just like the VLOOKUP function in Excel?
I'm a developer with Cognito Forms.
Calculations can be used to pull values out of other fields on your Cognito Form, and use them in different ways. You can display them or use them in a mathematical formula. You can also build blocks of text inserting the name field for the users name to help personalize an email response.
The ability to assign numeric values to Choice fields was also recently released. You can view a blog post that highlights the feature and its abilities.