XLOOKUP Complete Guide and Examples

Help me use XLOOKUP for my data lookup needs:

**Lookup Scenario:**
- What I'm searching for: [describe the lookup value]
- Where to search: [column/range containing lookup values]
- What to return: [column/range containing return values]

**Data Structure:**
- Lookup array: [e.g., B2:B100 - Product Names]
- Return array: [e.g., D2:D100 - Prices]
- Lookup value location: [e.g., F2]

**Advanced Options Needed:**
- If not found behavior: [error / custom message / specific value]
- Match mode: [Exact / Exact or next smaller / Exact or next larger / Wildcard]
- Search mode: [First to last / Last to first / Binary ascending / Binary descending]
- Return multiple columns: [Yes/No]
- Horizontal lookup: [Yes/No]

**Special Scenarios:**
- [ ] Two-way lookup (row and column)
- [ ] Return entire row
- [ ] Nested XLOOKUP
- [ ] With other functions (SUM, IF, etc.)

Please provide:
1. The XLOOKUP formula for my scenario
2. Explanation of each parameter
3. Comparison with VLOOKUP/INDEX-MATCH
4. Common use case examples
5. Error handling best practices
6. Performance considerations