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

[John]

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

 

[JulieD]

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