Re: How to Combine Two Lists and Add Values?
Ok, I think I've got what you need. These two pages gave me what I needed:
http://www.cpearson.com/excel/ArrayFormulas.aspx
http://www.cpearson.com/excel/MatrixToVector.aspx
I emailed you a sample Excel spreadsheet with your sample data and the result you wanted. Hope it helps.
__________________
Ursus - 2009 Ford Ranger FX4
BedRug, BakFlip HD, Pop&Lock PL8200 tailgate lock, Sportz tent
|