AVT100 Filter & Extract Data add-on for Google Sheets 12-month subscription ID 24272391
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.
