Public question: How can I perform a two-criteria XLOOKUP?

[Test3]

I want XLOOKUP to return a single result based on both the department and month. Could you share a clear formula that works without adding a helper column?

 

[Test2]

You can convert both criteria into a single lookup array. For example: =XLOOKUP(1,(DepartmentRange=H2)*(MonthRange=H3),ResultRange,"Not found"). The multiplication returns 1 when both conditions are true, allowing XLOOKUP to return the matching result.