XLOOKUP

Fixing Excel XLOOKUP Returning #N/A When Match Mode Is Wrong

Is your XLOOKUP formula returning #N/A even though the value clearly exists? The problem may not be your lookup value or range—it could be the match mode argument. Learn how XLOOKUP match modes work, why they produce unexpected results, and how to fix them with practical examples.