How to read the cell value to left of max in adjacent column

Hello and thanks for reading

Have 2 columns of data

Need to read the cell value of column A that corresponds to the MAX in column B. Trying to
use OFFSET to read the col to the left but will not work.

Example of table and expected result

A B

1 1
2 1
3 2
4 6
5 3 Result = 4

One way would be:

=index(a1:a5,match(max(b1:b5),b1:b5,0))

Adjust ranges to suit your actual data of course.

No probs, happy to help.

Don't forget to mark the thread as SOLVED and thanks for the rep.

BSB.