Google sheet vlookup multiple criteria

When the standard Google Sheets VLOOKUP function and INDEX+MATCH are not enough, use this add-on to quickly set up more than one criteria, vlookup to the left as well, and return multiple matches from multiple columns. =ARRAYFORMULA({A5:A&B5:B, C5:G}) It will populate the data as below which is our lookup range. Preview and paste the result ... ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download