Is this simple I'm trying to compare values from 4 excel tables
 

I am trying to create a method to compare pricing on 2 products from 4 sources.
Here is what I'm thinking but am not sure if the thinking is right here is
how I'm thinking of proceeding:

1. The label of the 4 columns changes so I need to try to determine the
value of each column before comparing highest price.
2. I want to copy the 10 values and paste them into a result table.
3. Compare a value in each of the 4 tables and paste the highest value in
the result table.

I am trying to produce this output table daily thus I think I need to add
some functions into the work sheet?

Any ideas?

Thank you in advance

Hi John

by the sounds of it the MAX and LOOKUP functions will work for you
e.g.
with the prices in B2:E2 and the source names in B1:E1
=MAX(B2:E2) will give you the highest price
=LOOKUP(MAX(B2:E2),B2:E2,$B$1:$E$1)
will give you the source with the highest price
use these formulas to put the maximum values into another table

Cheers
julieD

"John" wrote in message
...
I am trying to create a method to compare pricing on 2 products from 4
sources.
Here is what I'm thinking but am not sure if the thinking is right here is
how I'm thinking of proceeding:

1. The label of the 4 columns changes so I need to try to determine the
value of each column before comparing highest price.
2. I want to copy the 10 values and paste them into a result table.
3. Compare a value in each of the 4 tables and paste the highest value in
the result table.

I am trying to produce this output table daily thus I think I need to add
some functions into the work sheet?

Any ideas?

Thank you in advance