Tipps zu SVERWEIS und anderen Formeln

Mobile Offline
1

Message
sverweis wäre super und andere formeln

Platform
iOS

Appversion
2.12.26

Deviceinfo
User Device: Apple - iPhone 8 - Handset - 16.7.8

Source
Review

App
Jotform

Hi helenakaratassios,

Thanks for reaching out to Jotform Support. Our German Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in German, let us know and we can have them do that. But, it might take a while until they're available again.

Now, coming back to your question, VLOOKUP itself isn’t a built-in feature in Jotform, but you can achieve similar functionality depending on what you’re trying to do. Here are a few tips and alternatives:

1. Use Spreadsheet Widgets - If you want to look up values inside the form, you can use the Spreadsheet to Form widget. It lets you upload an Excel or CSV file, then use a unique key to auto-fill other fields based on that row. Explore our guide on How to Use the Spreadsheet to Form Widget to dive in deeper.

2. Use Calculation Conditions - For smaller datasets, you can use Update/Calculate Field conditions to automatically populate fields based on a user’s selection.

3. Integrate with Google Sheets - If your data is in Google Sheets and you want live lookup functionality, connect your form to Google Sheets using Jotform’s Google Sheets integration.

If that’s not quite what you’re looking for, can you share a bit more info so I can help you better?

Let us know if there’s anything else we can do for you.