returning a text value using a formula

[KVSmith59]

There is probably an easy solution to this, but I can’t find it. Any help
would be appreciated. I have 3 columns. Each column has a heading with
numbers in each one, and a total at the end of each one (totaling all of the
column numbers together). I’ve set up a formula(MAX) that returns the
highest number of the 3 columns. What I’d also like to do is have the
heading for that highest number be returned in a cell next to the cell with
the MAX formula. For example:

Cells G3, J3, and M3 have the column headings (text)

Cells G10, J10, and M10 have the “total†numbers

Cell B13 has the MAX formula and the highest "total" number is returned here

I’d like to have cell B14 show the corresponding heading for the number that
shows up in B13

So, if cell J10 has the highest number (say 16) and has a J3 heading of “Par
4â€, B13 will return 16 and B14 will return “Par 4â€

Any help you can provide would be appreciated!

Kevin

 

[Bob Umlas, Excel MVP]

This answer is based on the idea that there may be extraneous (unwanted)
values in H,I,K,L.
in B14:
ctrl+shift+enter:
=INDEX(G3:M3,MATCH(G14,(N(MOD(COLUMN(G:M),3)=1)*G10:M10),0))