VLOOKUP return incorrect values

J

John

Vlookup only returns the first match in the list, not
sure on a work around on this, maybe you also need to
have a summary of codes that exist more that once in the
data range, and these are the exception. Another why is
to make the entry unqiue by sum other means and lookup
by the unquie reference.

Maybe some of the MPV's can help, I'm still learning.

Regards

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top