Vlookup on Multiple Fields and Extend it with ArrayFormula - Google Sheets
Need to match on multiple keys? Want to extend that formula through you data with arrayformula? Can't quite make it work with Filter() or Query(). Learn how here.
https://docs.google.com/spreadsheets/...