Hi
use a pivot table. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"tbaldwin" schrieb im Newsbeitrag
...
Ive got a data sheet listed with product id's, the product, region
prod was
sold in, sales channel, and total sales. I need to create a lookup
that will
allow me to pull up a product and get a break down of sales by region
and by
sales channel. How can i do this?