I want to use LOOKUP to average multiple values for a single crite
 

Assumptions:
Col A - Vendor
Col B - Item
Col C - Cost
Col D - Cost+Tax
Col E - Cost/oz.

Data starts in Row 2
Data range is A2:E8

Criteria - Item - is in cell G2

Formula:
=SUMIF(B2:B8,G2,E2:E8)/COUNTIF(B2:B8,G2)

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"N_baker" wrote:

Okay, my data set has...

Columns: Vendor Item Cost Cost+Tax Cost/oz.

The items come from multiple vendors...

What would be the easiest way to lookup the items individually and calculate
the average cost/oz for each item, summarizing the averages in a separate
worksheet?