How to vlookup two workbook

December 13, 2010 at 03:50:41
Specs: Windows XP
i have source and a destination workbook and in the source, i have one vendor working for different companies. when i use vlookup, it links only the first company to the vendor leaving the rest behind. which formula can i use?

See More: How to vlookup two workbook

Report •

December 13, 2010 at 19:49:48
VLOOKUP (or any of the LOOKUP function, for that matter) will only find the first occurrence of a value in a list.

Depending on what you are trying to do, there are workarounds for finding multiple occurrences. A few different methods can be found there:

Google around for more.

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •
Related Solutions

Ask Question