2 criterias to organize data by VLookup

Hey,

I cannot use average prices for each company. Because I will be comparing prices of different items. For example: I quote very expensive item on one company and cheap items in the other company, this way it will look like one company had higher prices than the other, and its not true.

For the items yes, simple average for each item will do just fine.

For the companies I don't know. Those are insurance prices. So I cannot compare insurance of a truck with insurance of a small car. I cannot compare insurance price of an imported car with a national car.


P.S.: Maybe a dispersion graph will be good. So I have each item a small dot, each company a color of that dot. The X axis the price. So I look at the graph and I can see that if the right part of the graph is populated with more greens I know the green company is more expensive.

P.S.2: Maybe time should go on X and price on Y. Im trying to make that.