Your VLOOKUP formula should return one clean match, but Excel shows #N/A, #REF!, #VALUE!, #NAME?, #SPILL!, an old result, or the wrong value. The fix depends on what failed: the match setting, the ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results