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

C

cara

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.
 

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

Help With VLOOKUP 2
If equation with a VLookUp 3
For Eachcell in Range tranpose comma seperated values to a list in D 4
Using IF function and validation/list 0
Nested IF 2
VLOOKUP and #N/A 2
How do I get started using the Countif, Countifs option with Excel 2
IF calculation of Time 2

Top