What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    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,

    Greetings.

    excel JotForm application form Comments VLOOKUP Excel function Excel functions
  • Profile Image
    JotForm Support

    Answered by Boris on May 14, 2016 at 01:36 PM

    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:

    https://widgets.jotform.com/widget/data_grid (guide: How to Add a Widget to your Form?)

    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:

    https://form.jotformpro.com/form/50551155278960

    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:

    https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

    Similarly to the above, you can also forward your submissions to Google Spreadsheets, and then perform the Excel functions there:

    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet