Always Pair VLOOKUP with ISNA (or IFERROR)
🔒
https://dev.to
«The Problem
VLOOKUP returns a #N/A error when the lookup value isn't found.
=VLOOKUP(A2, ProductMaster!A:B, 2, FALSE)
If the value in A2 doesn't exist in the product master, the cell shows #N/A.
That's annoyi...»
Automatische Weiterleitung...
1.5s