VLOOKUP Return Incorrect Values

  • Thread starter Thread starter Glenn Weeks
  • Start date Start date
G

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.
 
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?).
 
Back
Top