App Icon
Ablebits
•  39,946
Overview
User-friendly tool to look up values based on criteria and return ALL matching data. Copies and inserts found matches as values or creates formulas
Multiple Vlookup Matches for Google Sheets is an advanced alternative to the VLOOKUP and INDEX & MATCH functions. The add-on doesn't simply fetch a record for a criterion as the function does. It returns multiple matches based on multiple conditions. What's more, you can change the criteria on the go and preview the new result before pasting it to your spreadsheet. 

The drill is quick and easy and takes ONLY 3 STEPS: 

  • pick the table you want to process
  • set as many conditions as you need
  • specify if you want to get all or only a number of matches

The add-on then scans your data and builds a new dataset in a place of your choice based on your requirements. 

SET CONDITIONS ON THE FLY

With the intuitive interface of the tool, there's no need to learn how to properly enter dates and time in Google Sheets anymore. Built-in operators will help you set your criteria on the fly. They adapt to your spreadsheet locale so you could enter dates and time as you do in daily life. The add-on will scan your data for exact or partial matches, compare values, or find records belonging to a certain period of time. 

SEARCH IN ALL DIRECTIONS

While the standard VLOOKUP cannot look at its left, our tool retrieves records from all directions. Simply select those columns you want to see in the resulting table. At your option, Multiple Vlookup Matches will present everything as pure values or as the QUERY formula that you'll be able to use and edit later.

The add-on also serves as a standard FILTER REPLACEMENT. Instead of jumping from column to column creating conditions, you can arrange everything within one window. Our tool will find all matches and copy them outside of your table without modifying it.

30 DAYS OF FREE USE

Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

Multiple Vlookup Matches is a proud member of the Ablebits product family. We build add-ons that help you make the most of G Suite. Visit our official website https://www.ablebits.com/google-sheets-addons to learn more.

If you have any questions please post them here: https://www.ablebits.com/docs/google-sheets-multiple-vlookup-matches/ 
We'll be happy to assist!
Reviews
Language:
Sort by:
Profile Picture
A User of Multiple VLOOKUP Matches
May 18, 2020
Excellent add-on, highly recommended. Had some minor technical issues at the very start, but I emailed support and they sorted out the issue within less than 24 hours. Makes dealing with large datasets significantly easier. Works well and saves a lot of time.
Is this review helpful?
Yes
No
Profile Picture
A User of Multiple VLOOKUP Matches
April 9, 2020
Didn't work, clicked submit as other user was asked, nowhere to paste the screenshot! Will wait and see what happens. I have installed and reloaded page, then started add on and the box comes up and it is blank, I get a short "Working" box then nothing. I am logged in on a chromebook to only 1 account, I tried signing out then back in and still not working!
Is this review helpful?
Yes
No
Profile Pciture
A user of Multiple VLOOKUP Matches
April 10, 2020
Hello, Sorry to hear you've encountered difficulties with the add-on. This is a simple feedback page so you won't be able to attach anything. We highly encourage you to contact our support team directly (the Support link at the very bottom of this page) with all the details of the problem. We'll do our best to assist you.
Profile Picture
James Goodman
February 10, 2020
Life saver - great!
Is this review helpful?
Yes
No
Profile Picture
A User of Multiple VLOOKUP Matches
October 22, 2019
Doesn't work. Literally does nothing when you activate it.
Is this review helpful?
Yes
No
Profile Pciture
A user of Multiple VLOOKUP Matches
October 23, 2019
Hello, Please click Support under the comments section and email us with a screenshot of what you see after the activation. We'll look into the problem and do our best to make the tool work for you.
Profile Picture
A User of Multiple VLOOKUP Matches
October 15, 2019
Great job! As always on top
Is this review helpful?
Yes
No
Profile Picture
A User of Multiple VLOOKUP Matches
October 14, 2019
Thanks! Using the add-on is much more convenient and faster than creating complex formulas manually!
Is this review helpful?
Yes
No
Profile Picture
A User of Multiple VLOOKUP Matches
October 14, 2019
Super! A very useful tool!
Is this review helpful?
Yes
No
Profile Picture
A User of Multiple VLOOKUP Matches
October 14, 2019
Thanks! It is really helpful!
Is this review helpful?
Yes
No
Profile Picture
A User of Multiple VLOOKUP Matches
October 14, 2019
the add-on is so cool! makes my job with formulas waaay easier!
Is this review helpful?
Yes
No
Profile Picture
A User of Multiple VLOOKUP Matches
October 14, 2019
Easy! The best way to save time for creating a loooooong formula. Thanks guys.
Is this review helpful?
Yes
No
1-10 of 10
Additional information
Ablebits
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu