Jen,

=INDEX(A:A,MATCH("X",B:B,FALSE))

HTH,
Bernie
MS Excel MVP


"Jen1170" wrote in message
...
I am trying to find help for a formula if possible. I have 2 columns (A, B)
and several rows beneath. Column A is all names. In column B there will be
an "X" next to one name. How can I create a formula to give me the name from
column A when there is an X in column B? Hope that made sense! Thanks.