| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
| Disable dropdown list (Combo box -"Form control") | Excel Worksheet Functions | |||
| function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| Questionnaire sheet: Select "yes" or "no," and only one can be selected | Excel Worksheet Functions | |||
Linear Mode
