What is the default match type of XLOOKUP?
- A Approximate match
- B Exact match
- C Wildcard match
- D Reverse match
Answer
Exact match
This is safer than VLOOKUP, where omitting the fourth argument defaults to approximate match and silently returns wrong answers on unsorted data.





