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)...
HansVogelaar you've helped with something similar, do you think you could help with this one. It doesn't have to be an XLOOKUP
The layout of the 12-4 sheet makes it complicated for a formula. I have attached a workbook with a custom VBA function GetEP. You'll have to allow macros when you open it.
