#N/A
Excel and SheetsWhy it appears
A lookup could not find the value.
How to fix it
Check for extra spaces and numbers stored as text. Use IFNA or the if_not_found argument of XLOOKUP for expected gaps.
A lookup could not find the value.
Check for extra spaces and numbers stored as text. Use IFNA or the if_not_found argument of XLOOKUP for expected gaps.