returning a text value using a formula
 

There is probably an easy solution to this, but I cant 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). Ive set up a formula(MAX) that returns the
highest number of the 3 columns. What Id 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

Id 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

returning a text value using a formula
 

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)*G1 0:M10),0))

"KVSmith59" wrote:

There is probably an easy solution to this, but I cant 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). Ive set up a formula(MAX) that returns the
highest number of the 3 columns. What Id 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

Id 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