When a formula cannot find a match, Google Sheets often shows #N/A. That is not a crash and it is not a broken file — it is the function reporting that the lookup value is missing from the search range.

Steps