#N/A
#N/A Error in Excel — Causes & Fixes
Excel returns #N/A when a formula cannot find the value it is looking for — most often in VLOOKUP, XLOOKUP, MATCH, or HLOOKUP.
Excel has 7 formula error types. Each one means something specific. Pick the error you are seeing and get the exact fix.
#N/A
Excel returns #N/A when a formula cannot find the value it is looking for — most often in VLOOKUP, XLOOKUP, MATCH, or HLOOKUP.
#REF!
Excel shows #REF! when a formula contains a cell reference that no longer exists — usually because a row or column was deleted.
#VALUE!
Excel returns #VALUE! when a formula receives the wrong data type — for example, trying to add a number to a text string.
#NAME?
Excel shows #NAME? when it cannot recognise text in a formula — usually a misspelled function name, a missing quotation mark, or an undefined named range.
#DIV/0!
Excel returns #DIV/0! whenever a formula attempts to divide by zero or by an empty cell.
#NULL!
Excel returns #NULL! when two range references in a formula are separated by a space instead of a comma or colon, resulting in an empty intersection.
#NUM!
Excel returns #NUM! when a formula produces a number that is too large, too small, or mathematically impossible — such as the square root of a negative number.
Still stuck?
Paste your broken formula into the checker and review likely issues.
Open formula checker