Forum Discussion

Copper Contributor

Jul 12, 2022

Solved

Look up a value and return the cell to the left

Hi, I am trying to look up the text with the highest value in each row. The data currently is orgnaised in this way (attached a screenshot). I am able to get the max value in each row, but I could n...

excel

Formulas and Functions

Lorenzo
Jul 12, 2022
Hi JoanneYu

in B2:
=MAX(C2:H2)
in A2:
=INDEX(C2:H2, MATCH(B2,C2:H2,0)-1)

Lorenzo

Silver Contributor

Jul 12, 2022

Hi JoanneYu

in B2:

=MAX(C2:H2)

in A2:

=INDEX(C2:H2, MATCH(B2,C2:H2,0)-1)