Please help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Copy corresponding cell in Column B if cell in A contains certain text? 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
IF formula for currency or Macro help. 0
How to count the maximum number flanked by zeros 9
Excel Help with dates 2
Array Help? 4
Hide columns based on row values 2

Back
Top