Excel
XLOOKUP with Multiple Criteria: Real-World Excel Scenarios
Many business problems require lookups based on more than one condition. XLOOKUP combined with logical arrays makes this possible.
The Concept of Multiple Criteria
You can combine multiple conditions by multiplying logical tests.
XLOOKUP with two criteria
=XLOOKUP(1, (A:A=E1)*(B:B=F1), C:C)