Forum Discussion
Formula With Multiple Criteria -XLOOKUP
Attached is a report example that I was wanting help with a formula. I was going to use an XLOOKUP but need multiple criteria. I was trying to do an XLOOKUP if: 1. If (Totals) A3 is found in (12-4)...
I Hope it help you
=XLOOKUP($A$6&C2,'12-4'!$A:$A&'12-4'!$C:$C,'12-4'!$K:$K,0,0)