New on the blog: why AI belongs in the feed →

VLOOKUP to GravityOps Search Translator

Paste a VLOOKUP, XLOOKUP, INDEX/MATCH or FILTER formula from Google Sheets or Excel, tell the page which Gravity Forms field holds each column, and copy a [gravops_search] shortcode that runs the same lookup on your form entries.

The translator needs JavaScript. You can build the same basic shortcode in our Gravity Forms shortcode builder.

How each formula maps

  • VLOOKUP(value, table, column, FALSE): the table’s first column becomes search, the column you return becomes display, and the value goes between the opening and closing tags.
  • XLOOKUP(value, lookup range, return range): the same, and a return range that spans several columns becomes several display fields.
  • INDEX(return range, MATCH(value, lookup range, 0)): read exactly like VLOOKUP.
  • FILTER(range, condition): the condition’s column becomes search, every column in the range is displayed, and limit="all" returns every match instead of one.

Differences worth knowing

  • A spreadsheet lookup returns the first match from the top of the sheet. GravityOps Search returns the most recent matching entry unless you sort the results.
  • The shortcode matches exact values. Approximate matching (VLOOKUP with TRUE), wildcards and comparisons such as >100 need operators.
  • Your formula usually reads the lookup value from a cell. In WordPress, type a fixed value, or use a merge tag such as {Email:3} where Gravity Forms fills merge tags in, for example in a notification or confirmation.

Free plugin, Premium builder

Every shortcode this page writes runs on the free GravityOps Search plugin. When your formula does more (several conditions, comparisons, sorting, a fallback when nothing matches, unique results), the page lists what it needs. GravityOps Search Premium adds a point-and-click Shortcode Builder to your dashboard that sets those up with a live preview and a library of saved shortcodes.

Questions

Where do I find field IDs?

Open the form in the editor and click a field: the ID shows in the field settings. Form IDs are in the ID column of Forms → Forms. Use 0 as the form ID to search every form.

Does the page save or send my formula?

No. It runs entirely in your browser. Nothing you paste leaves the page.

More free tools: the Gravity Forms shortcode builder and our Gravity Forms code snippet library.