I am trying to determine a lookup or find formula that will find data in 1
column and return the data from the 2nd column but the data in the 1st column
is not in ascending order and I do not want to sort it to be in ascending
order.

Ex A B
1 Sue 5
2 Bob 3
3 Max 4

I want to find Sue and return value 5 for this above array and I do not want
to sort the data.