combining 2 different lists

Microsoft Excel 2003 (full product)
April 23, 2010 at 11:57:12
Specs: Windows XP
I have a large list of companies that have e-mail addresses. Then I have a second smaller list of just companies, I would like a formula that would compare the names on the small list and the large list and when there is a match to put the e-mail from the large list into a new column in the small list.

See More: combining 2 different lists

Report •

April 23, 2010 at 13:00:46
VLOOKUP() should do it for you.

Why not look up the function in Excel Help and see it you can make it work/

If not, come on back and we'll see if we can help out.

Report •
Related Solutions

Ask Question