Combined list from two lists

**kumawat_s** · 06-08-2010, 03:58 AM

I have two lists A & B having product name and quantities sold.

Some products of list A is not exist in list B and some product of B list not exist in A list.

How can I get a combined list having all the products and quantities sold.

I am using excel XP.

Thanks

shubhkaran

**teylyn** · 06-08-2010, 06:11 AM

Have a look here

http://www.excelforum.com/2273908-post4.html

**kumawat_s** · 06-08-2010, 07:47 AM

Thanks for reply.

I am using excel 2002 and the attached file is not accessable.

Please help.

Thanks

shubhkaran

**teylyn** · 06-09-2010, 08:20 AM

kumawat,

here's the file from the referred post, saved in XL 2003 format and with formulas adjusted to suit Excel 2003. This should work in earlier versions, too.

cheers