Merging lists with one common column but some different names

Posted by nathan on November 16, 2001 12:32 PM

I have one list of vendors with YTD amount totals in one workbook and a master vendor list for 4 years worth of active and inactive vendors, but all of my first list names are within the master....how do I
merge the information of addresses in the master with
my ytd list? anyone know?

thanks!

Posted by Barrie Davidson on November 16, 2001 12:53 PM

Use a vertical lookup. See

http://ca.geocities.com/b_davidso/Web_Page_Files/Excel/lookup.html#VLOOK

for an example of the correct syntax. If you need any further help just let me know via this board.

BarrieBarrie Davidson

Posted by nathan on November 16, 2001 1:16 PM

Re: =VLOOKUP works great! Thank You!