Formulas2 min read
Why your VLOOKUP returns #N/A when the value is clearly there
Nine times out of ten it is not the formula. It is an invisible character, a number stored as text, or an approximate match you never asked for.
EMElena MarshHead of Content, former FP&A Manager