How to do if I would like to select from a list by using "IF" form
 

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.

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.

How to do if I would like to select from a list by using "IF"
 

Thanks!

"T. Valko" wrote:

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.

How to do if I would like to select from a list by using "IF"
 

You're welcome!

--
Biff
Microsoft Excel MVP


"cara" wrote in message
...
Thanks!

"T. Valko" wrote:

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.