Hello All:

I would like to know how can I find out the folowing. I have a chart like
this:

Type Company 1 Company 2 Company 3
Product
Plastic 3.69 0.79 0.89
Metal 0.99 2.57 1.99
Wood 1.69 0.89 0.99

If I type in a cell A1 Plastic, then then cell A2 should tell me the highest
price found in the row for plastic.

I also want to be able to type plastic in A1 and then in B1 wood and in cell
A2 should calculate the total highest price for both.

Thanks in advance for any help.