Lookup with Multiple Criteria Solutions

I need to look up a value based on multiple criteria:

**Lookup Scenario:**
[Describe what you're trying to find based on which conditions]

**Criteria Details:**
| Criteria # | Column | Match Value |
|------------|--------|-------------|
| 1 | [e.g., Column A - Region] | [e.g., "North"] |
| 2 | [e.g., Column B - Product] | [e.g., "Widget"] |
| 3 | [e.g., Column C - Year] | [e.g., 2024] |
| Add more if needed | | |

**Return Value:**
- Column containing result: [e.g., Column D - Sales]
- If multiple matches: [return first / sum all / average / count]

**Data Sample:**
[Paste a few rows of your lookup table]

**Excel Version:**
- [ ] Excel 365 (has XLOOKUP, FILTER)
- [ ] Excel 2019 or earlier
- [ ] Google Sheets

**Current Attempts:**
[What have you tried that isn't working?]

Please provide:
1. INDEX-MATCH with multiple criteria
2. XLOOKUP approach (if available)
3. SUMPRODUCT method
4. FILTER function approach (if available)
5. Helper column alternative
6. Comparison of methods and when to use each