JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Is there a way to emulate the VLOOKUP function of Excel?Asked by procesos on May 14, 2016 at 12:36 PM
JotForm team would like to know if there is any alternative to simulate through some widget or application form or another deemular buscav Excel function in a form.
I remain attentive to your comments, thank you very much,
We do not have a VLOOKUP function available on our forms, but depending on your needs, you may want to use our Data Grid widget:
Data grid widget allows you to present data on your form in a grid/table, which is sortable by clicking on the header of any column, and it also has a filter bar at the top, as can be seen on the demo form:
On the other hand, if you were looking to perform VLOOKUP-like functions on the data that your users have submitted, you may want to export your submissions in Excel format and use the VLOOKUP function of your spreadsheet software:
Similarly to the above, you can also forward your submissions to Google Spreadsheets, and then perform the Excel functions there: