Jotform Tables: How to show value as VLOOKUP function in Excel?

Hi there,

In the TABLE 1 , I need to fill in "price" column based on "Item Name" Column which is filled by assignee. The price is in "FOB TABLE" (2nd photo). I used LOOKUP function but I must manually select items (item column). I need it show value as VLOOKUP function in EXCEL.

Pls advise me

Thanks so much.

Hi trucanh145,

Thanks for reaching out to Jotform Support. I understand you're looking to automatically populate the "price" column in TABLE 1 based on the "Item Name" selected, using data from your "FOB TABLE," similar to Excel's VLOOKUP function. However, unlike Excel's VLOOKUP, Jotform Tables requires manual selection of the lookup field. You can use the Lookup function within Jotform Tables.

This formula tells Jotform Tables to find the "Item Name" in your TABLE 1, then search for that item in the "Item" column of your "FOB TABLE," and finally, return the corresponding "Price" from the "FOB TABLE."

Alternatively, if you need a fully automated solution, you may consider integrating Jotform with Google Sheets and use Excel's VLOOKUP feature. Let me show you how to integrate your form with Google Sheets:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings. In the menu on the left, click on Integrations and select the Google Sheets integration.
2. Click on the Add New Action button.
3. Now, select an action and click on Next. Then, click on Add Action and customize settings as you want.
4. Once you finish customizing, click on the Save button at the bottom right of the settings.

If you select Create new spreadsheet, a new spreadsheet will be created in your Google account, where submissions will be collected. If you select Use existing spreadsheet, submissions will be collected in the spreadsheet you choose, which is already connected to your Google account. We also have a guide about How to Integrate Forms With Google Sheets that you can check out.

Reach out again if you need any more help.

Thanks for your response

Can you guide me to do this :

"This formula tells Jotform Tables to find the "Item Name" in your TABLE 1, then search for that item in the "Item" column of your "FOB TABLE," and finally, return the corresponding "Price" from the "FOB TABLE."

There is no way to place to choose FIND "Item Name" in lookup function.

Pls help me

Thanks alot

Hi trucanh145,

I understand what you’d like to do, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

Thanks for your patience, we appreciate it.

Hi trucanh145,

I am still looking for a solution. Give me more time for this. I'll be back as soon as I can.

Thanks for your patience, we appreciate it.

Hi Jeric,

I initially thought this function was basic, but it seems that's not the case!

Can you help me find the solution for this issue asap?

I need to link 5 forms by Unique ID which is Item Name. After connected with 5 forms, I need to create 5 item columns of each form, then manually choose item name for each column. This is super silly!

It is urgent, so pls help me soon

Hi trucanh145,

Sure, here's how you can create a Lookup Formula on the Tables.

1. In Submission Tables, click on +Add in the last column.
2. Now, click on Formula.
3. Next, select Lookup.
4. Click on Add a Connection Column.
5. Click on Connect a Table.
6. Click on Next.
7. Select the Table and the field/s you want to connect.
8. Finally, click on Create Column.

We also have this guide about using the Lookup function.

Reach out again if you need any other help.

Hi Jeric,

Thanks for your answer, but it does not work.

Can you re-read my question? Your answer is what i have done and failed.

I need to lookup the ITEM ID column in the first table, I don't want to create a new Item ID which is connected to FOB table, then manually select.

Thanks so much

Hi trucanh145,

To clarify, you have 5 tables that you wanted to connect to a main table, and create 5 lookup columns for the Item Name, is that correct? When I checked, you can only create a Lookup formula for one connected table. If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Once we hear back from you, we'll be able to help you with this.