I have one sheet with two columns, one "NAME" column and one "VALUE" column.
In the next sheet, I want to find the max value from the "VALUE" column, but show the name from the "NAME" column.
Is there a simple way to do this?
A simple INDEX/MATCH with MAX will do it:
=INDEX(Sheet1!A:A,MATCH(MAX(Sheet1!B:B),Sheet1!B:B,0))
Make sure your numbers are true numbers and not numbers stored as text. MAX will ignore the numbers stored as text.
;
instead of ,
to delimit the parts of the formula?
Feb 5, 2019 at 16:09