Fix #N/A in VLOOKUP

vlookup errors iferror

Show Not found instead of #N/A, and clean stray spaces with TRIM.

The problem

VLOOKUP shows #N/A when the value is not in the list.

Formula

=IFERROR(VLOOKUP(TRIM(E2),$A$2:$D$5,4,FALSE),"Not found")

Sample: " INV-3 " (with spaces) returns 300; INV-9 returns Not found.

Caution

IFERROR hides every error, not only #N/A. Check the Not found rows. Same in Excel and Sheets.

Tested on sample data by the Cellwise checker (logs CW-PL-20261018-40 and -44). AI-made: the text, voice and visuals are generated by AI.

Checked before publishing: a check.