Is it possible to look up a value based on a value entered in a field – just like the VLOOKUP function in Excel?
Cognito-forms – Lookup a value
cognito-formsvlookup
Related Topic
- Cognito Forms – How to Validate Two Fields Have Same Value
- Google-sheets – Return cell reference containing closest value
- Google-sheets – Arrayformula for entire column in Google Sheets with a lookup not working
- Cognito-forms – Cognito Forms: Lookup Value
- Google Sheets – Fix VLOOKUP Not Finding Entry from Formula
- Google-sheets – Searching cells and pulling values in Google Sheets
Best Answer
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.
You can check the Cognito Forms help topic for more information on calculations, as well as conditional logic that you can set up.