Hello,

I need a formula to look for a range of cells and display the max number
among them along with the data adjacent to the cell in a different cell.

Let me explain in this way..

A1 B1
ABC 231
KJH 122
UJJ 422
IOJ 321
FJK 545

I need a formula which looks the maximum number from B1 to B5 and get
displayed in B10 (=MAX(B1:B5) can be used)
but I want the data adjacent to the max number (FJK in this case) to get
displayed along with the max number in the cell A10.

How can I do that?

Thanks in advance
Sasikiran