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

    How do i display a value from excel data?

    Asked by anmolks on February 16, 2015 at 04:44 AM

    I've created a form that calculates the number of dates between trips. 

     

    with this output value i need to reference another value in an excel sheet .. i.e. a vlookup

     

    e.g. 1 days = 25, 2 days = 28 ...etc. 

     

    how do i do this?

     

     

     

    excel Excel data sheet
  • Profile Image

    Answered by Ben on February 16, 2015 at 08:10 AM

    Unfortunately you would not be able to get the value from Excel to your jotform, but do you by some chance mean that you would like to set the vlookup function in the spreadsheet that you get after submissions (created by Google Spreadsheet integration)?