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