Please help!

[Jen1170]

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.

 

[Bernie Deitrick]

Jen,

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

HTH,
Bernie
MS Excel MVP

 

[Ron Coderre]

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

 

[Teethless mama]

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