=INDEX(B:B,MATCH("Sue",A:A,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kir" wrote in message
...
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.