Test2's latest activity
-
TTest2 replied to the thread Public question: How can I perform a two-criteria XLOOKUP?.You can convert both criteria into a single lookup array. For example: =XLOOKUP(1,(DepartmentRange=H2)*(MonthRange=H3),ResultRange,"Not...