can I look up the maximum value in 2 columns?

[wildecoyote1966]

Can I look up the maximum value in two columns?

Cell I3 to I5 have basically this code

Please Login or Register  to view this content.

is the code I used but I had to split the table so now I need it to also show the max value in column K14:K108.

Cells J3 to J5 look up those values and return the date in column A

Please Login or Register  to view this content.

currently looks up D but I need it to look up column K as well (in this formula)

[Glenn Kennedy]

The maximum value:

=MAX(D14:D108,K14:K108)

and, for the value:

=IFERROR(INDEX($C$14:$C$200,MATCH($I$3,$D$14:$D$200,0)),INDEX($J$14:$J$200,MATCH($I$3,$K$14:$K$200,0)))

Revised formula in I3 & J3, only.

[wildecoyote1966]

Hi Glenn.

Thanks for that.

I'm considering making a table so I can work out exactly how much the panels have made.

Over here electricity is charged at different rates at different times of the day.
I think I have 4 different charge times.

This current sheet just shows the feed in tariff and the usage charge over the electricity purchased.

Albert