=INDEX(AB18:AB22,MAX(IF(NOT(ISERROR(LEFT(AB18:AB22 ,FIND("@",AB18:AB220)-1)=A
B17)),ROW(AB18:AB22)-MIN(ROW(AB18:AB22))+1,0)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jrose" wrote in message
...
Hello, Again i find myself in need of what should be an easy formula...but
unable to find what i need. I appreciate any help.
I have a small list of email addresses (AB18:AB22). I have a pull down
menu
linked to cell AB17 with the peoples name in it. I simply want one cell to
display the email address of the person chosen in the pull down. This
seems
too simple to even ask.... Thanks