Leverage your VLOOKUP experience with the QUERY function
Multiple 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.
