Find the error. Fix the sheet.

Short walkthroughs you can type into a sheet.

Browse by error

Match the value in the cell, then open the page. Each one is a blank-sheet recreate, what is actually wrong, and a formula you can type.

#N/ANo match. VLOOKUP, MATCH, and FILTER all use this. Confirm the miss before you wrap it.

#REF!The reference is gone after a delete. Different from a circular loop or a VLOOKUP index past the range.

#DIV/0!Divide by zero, or by a blank cell that counts as zero. Guard the divisor.

#NAME?Unknown function or name. VLOKUP is not VLOOKUP. Not a locale parse error.

#VALUE!Wrong type. 10 + pcs is #VALUE!. Not a lookup miss and not a parse error.

#NUM!Number out of domain. SQRT of a negative is #NUM!. Guard the input.

VLOOKUP #N/AThe sku is on the sheet and VLOOKUP still misses. Number vs text, or a trailing space.

QUERY Col1 vs AQUERY on IMPORTRANGE needs Col1, not A. select A returns #N/A on that array.