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.

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.

Try one of these:

=LOOKUP("X",B2:B10,A2:A10)
or
=IF(COUNTIF(B2:B10,"X"),LOOKUP("X",B2:B10,A2:A10), "")

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jen1170" wrote:

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.

In C2: =IF(B2="x",A2,"")
Copy down


"Jen1170" wrote:

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.