I have a worksheet where I need to select a value based on which cell in a
non-contiguous range has the MAXimum value.

To be more specific,
There are 4 cells in column E (26, 35, 43, 47) each with values < 200.
There are 4 matching cells in column G.
If say E35 is the largest of the 4 values then the value in G35 is to be
used as part of a formula in G59.

I guess I could always create a contiguous table and use VLOOKUP but the
layout is repeated 200 more times down the sheet and I would rather save the
space. Besides, I just know there has to be a formula. I have played with
MAX and MATCH and CELL("row"

Is there another function I should look into. Any suggestions?

TIA
-- Len