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

    Help in configuring a result that needs to use "LOOK UP" in a range that will be contained (existing) in the same form?

    Asked by IanRm on May 27, 2017 at 05:01 PM

    have you any examples of a calculation that needs to use "LOOK UP" in a range that will be contained in the same form?

     

    I want to 'LOOK UP' for a value/result in a serious of cells in order to get a result 

     

    when we use this margin table in a spread sheet- this is what w ehave in the field that we want the result of teh LOOK Up to be populated into

    =VLOOKUP(FieldX,margintable,2,1)

    this is an example of the margin table:

    Can this be done in JOTFORM?

     

     

    Lookup Key Margin Value Or %
    € 1 € 45
    € 45 € 55
    € 75 € 75
    € 100 € 75
    € 150 € 85
    € 200 1.428571428570
    € 1,000 1.428571428570
    € 2,000 1.428571428570
    € 3,000 1.333333333333
    € 4,000 1.333333333333
    € 5,000 1.250000000000
    € 7,500 1.176470588230
    € 10,000 1.111111111111
  • Profile Image
    JotForm Support

    Answered by Mike on May 27, 2017 at 06:21 PM

    Unfortunately, the VLOOKUP function is not available at JotForm.

    JotForm Calculation - Math Function Reference

    If am not sure if this is something that may work in your case, but it is possible to assign values to the field items.

    How to Assign Calculation Value

    For example, if you have a dropdown you can assign different values to different dropdown items.