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!
Extore is a team of professionals who are passionate about creating extensions for web browsers. This devotion also gives us opportunity to appreciate work of other people. We get inspired by useful, open source extensions made by developers all over the world. Our strong belief is that one should share helpful add-ons with others. That’s why we’d like to present you our ever-growing list of favourite extensions that have inspired us. Moreover, as you probably have already learned, sometimes struggling for the best brings an end to the good. Talking about add-ons it often turns out that an upgrade is worse then previous version. Also it can become really tricky to get back to the beloved version of your favourite extension. That’s why we’re going to make not only the latest, but all versions of our favourite (and we hope yours too) add-ons available for download. No more compromises, just stick to the version you really like!
Preparing download link, please wait for seconds
Almost done...
Click to download
Error getting file. Please try again
