ConditionalVisibility

new-products-promo

vlookup-excel-image01

vlookup-excel-image02

vlookup-excel-image03

vlookup-excel-image04

vlookup-excel-image05

vlookup-excel-image06

App tips

Excel app tips hero image

Microsoft Excel

Here's how to use the VLOOKUP formula in Excel to quickly find and retrieve data in a spreadsheet.

How to use VLOOKUP in Excel

The days of exporting your form submissions by hand are over. Set up this integration and Zapier will do it for you from now on. Any new Jotform submission will automatically create a new row on an Excel spreadsheet with all the responses you want, ready to be sorted, calculated, and analyzed at your leisure.

The newly redesigned Jotform lets you build forms faster than ever, with powerful widgets and a responsive editor that works offline—without even needing to sign up for an account.

Jotform

Triggers when a new submission has been added to a specific form.

New Submission

Triggers when a signed document is received.

New Signed Document

Assign Form

Invite assignees to complete your pre-populated form

Assign Prefilled Form

Create Submission

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. 

Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Triggers when a new row is added to a worksheet in a spreadsheet.

New Row

Triggers when a new row is added to a table in a spreadsheet.

New Row in Table

Triggers when a new worksheet is added to a spreadsheet.

New Worksheet

Triggers when a row is added or updated in a worksheet.

Updated Row

Finds a row by a column and value. Returns the entire row if one is found.

Find Row

Finds any rows that match a specific value in a given column.

Find Row(s)

Find or Create Row

Adds a new row to the end of a worksheet.

Add Row

Adds one or more rows to the end of a worksheet (with line item support).

Add Row(s)

Adds a new row to the end of a specific table.

Add Row to Table

Create Spreadsheet

Update Row

Add new Jotform submissions to Excel spreadsheet rows

The faster your form submissions come in, the harder it can be to track and store them all. You can set up this Zap, however, to capture everything for you. It will trigger whenever a new form submission is received in Gravity Forms, automatically adding that information to a row in a specified Excel spreadsheet and keeping your sheet constantly up to date for all your ensuing processes.

Gravity Forms is a premier WordPress plugin that makes it easy to create powerful forms on the fly.

Gravity Forms

Triggers when the specified form is submitted.

Form Submission

Create Entry

Creates an entry and fires all events associated with a form submission such as notifications and add-on feeds.

Submit Form

Add new Gravity Forms submissions to Excel rows

Slack's search is a powerful tool, but if you're tired of the endless scrolling, set up this Zap to easily bring a copy of everything into Excel. It'll fire off whenever a new message is posted to a specific channel on Slack, automatically adding the contents to an Excel spreadsheet so you can sort by user, filter by content, or even simply keep a separate record of the valuable conversation that happens in chat.

Slack is a platform for team communication: everything in one place, instantly searchable, available wherever you go. Offering instant messaging, document sharing and knowledge search for modern teams.

Slack

Triggers when a new message is posted to any public channel.

New Public Message Posted Anywhere

New Channel

Triggers when a new message is posted to a specific #channel you choose.

New Message Posted to Channel

Triggers when a custom emoji has been added to a team.

New Team Custom Emoji

Triggers when a new file is uploaded to your workspace.

New File

Triggers when a username or highlight word is mentioned in a public #channel.

New Mention

Triggers when a new message is found that matches the query.

New Message From Query

Triggers when a new message is posted to a specific #private-channel or multi-dm.

New Message Posted to Private Channel

Triggers when you click the "Push to Zapier" button from a message in Slack.

New Pushed Message

Triggers when a reaction (aka reactji) is added to a message in a public #channel.

New Reaction Added

New Saved Message

Triggers when a new Slack user is created / first joins your org.

New User

Finds a Slack message using the Slack Search feature.

Find Message

Finds a user by matching against their email instead of their username.

Find User by Email

Find User by ID

Finds a user by matching against their real name instead of their username.

Find User by Name

Find User by Username

Adds a reminder for yourself or a teammate, just like the `/remind` slash command.

Add Reminder

Invite an existing User to an existing Channel. You must be a member of the channel to invite someone to it.

Invite User to Channel

Posts a message to the specific #channel you choose. Can also schedule a message for later.

Send Channel Message

Sends a direct message to a user or yourself from the Slackbot. Can also schedule a message for later.

Send Direct Message

Create Channel

Post a new message to a private channel you choose. Can also schedule a message for later.

How to use VLOOKUP in Excel

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.