Thread: How to do if I would like to select from a list by using "IF" form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default How to do if I would like to select from a list by using "IF" form
Try this:

=IF(COUNTIF(A1:D1,"contact"),"Y","N")


--
Biff
Microsoft Excel MVP


"cara" wrote in message
...
If A1~D1 ever shows "Contact", then the answer is "Y", otherwise "N"
=if(list(A1:D1)="contact", "Y", "N")
A B C D
1 no contact no contact contact no contact

How do I make the formula? Should I use VLOOKUP instead?
Please kindly help! Thanks a lot.


Reply With QuoteReply With Quote