XLOOKUP is powerful, but it can still break when lookup arrays and return arrays do not line up.
FormulaRescue helps identify common XLOOKUP issues and return a cleaner formula.
=XLOOKUP(A2,B:B,D:D)Works only if B:B contains the lookup values and D:D contains the return values.
=XLOOKUP(A2,B2:B10,D2:D20)Lookup and return ranges should usually be the same size.
=XLOOKUP(A2,B:B,D:D,"Not found")Adds a fallback instead of showing #N/A.
The lookup value may not exist, may have extra spaces, or may be in the wrong lookup range.
Yes, if the mismatch is visible from the formula or context.
Often yes, but the right formula depends on the workbook and Excel version.
Paste your broken Excel formula into the main FormulaRescue tool and get a corrected version back.
Rescue a formula