VLOOKUP Return Incorrect Values

[Glenn Weeks]

I've followed the Resolution Methods from Microsoft
Knowledge Base Article - 181201, but I am getting "N/A"
results where I shouldn't be. My formula (=VLOOKUP
(C4,$I$3:$J$162,2,FALSE) should find a match for 84 out of
159 items but it is only finding 1.

 

[Frank Kabel]

Hi
what kind of data is in C2 and what data in column I. Maybe different
formats, leading/trainling spaces, etc.
In addition VLOOKUP ONLY returns the first match. If you want to
process all matches you may explain what you're trying to do with the
matches (e.g. summing?).

 

[Glenn Weeks]

Thank you Frank,
It looks like trailing spaces was the problem.