help with sumproduct or vlookup

J

JR

Hello,

I input the following data on sheet one (there are many lines of data with
customers names. Please note that each line has a date so there is a quick
reference for a Vlookup).


B C D E

Product Sold Product Sold Product Sold
Crystal Cole HSI Dig Phone


On sheet two I would like to bring Data over so it looks like the following
(also keep in mind that I already have the name on this page, so some kind of
match would work great – each line on this page has a date as well).

B C
Crystal Cole HSI & Dig & Phone



Thanks
 
Top