SOLVED

Look up a value and return the cell to the left

Occasional Visitor

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 not figure out how to get its corresponding text. For example, A2 should be "0" (text 1) and A3 should be "user" (text 4).

 

The text number actually goes up to 124 (instead of just 9). A more efficient way to return the max value would be highly appreciated as well! Now what I can think of is only to click e.g., D2, F2 H2 etc. one by one... Thanks a lot!

JoanneYu_0-1657626738285.png

 

1 Reply
best response confirmed by JoanneYu (Occasional Visitor)
Solution

Hi @JoanneYu 

 

_Screenshot.png

 

in B2:

=MAX(C2:H2)

in A2:

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