AVT100 Filter & Extract Data add-on for Google Sheets Lifetime subscription ID 24272511
Business & Finance :: Office Suites & Tools
Leverage your VLOOKUP experience with the QUERY functionMultiple Vlookup Matches scans your entire table and fetches those records that match the conditions you set. Unlike the regular Google Sheets VLOOKUP function, the utility brings back each and every matching record and puts them into a new table. All you need to do is select the range and tweak the requirements. The tool will build a QUERY formula for you and paste it into the desired place.
