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 formula - 1
VLOOKUP and #N/A 2
IF calculation of Time 2
I need to do a calculation based on the values in two cells 2
For Eachcell in Range tranpose comma seperated values to a list in D 4
Searching for an additional item via an IF statement 5
array formulas using MIN MAX 3
Need Help with a Formula 5

Top