Excel: how to make a formula find the maximum value in a range and display the text in the line to the left of this value??

C

chief2016-12-12 11:57:50

Macros

chief, 2016-12-12 11:57:50

Excel: how to make a formula find the maximum value in a range and display the text in the line to the left of this value??
Task: There are 2 sheets. on the second table the values are written in lines like Ax - NUMBERS, Bx - TEXT.
Help me make a formula so that on sheet 1 in the cell to display the text from the maximum number.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

S

Saboteur, 2016-12-12
@saboteur_kiev

=LOOKUP(MAX(A1:A1000);A1:A1000;B1:B1000)

S

shushpanio, 2016-12-12
@shushpanio

=LOOKUP(MAX(list2!A1:A500),list2!A1:A500,list2!B1:B500)