| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function needed
I was curious if there is a formula that I can use to check if a cell
contains any of the values below? "Q3", "0308", "Q#3, "0408AU", "0408SL, "0408", "0109", "0209", "0309", or "0409" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function needed
Try
=IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU","0408 SL","0408","0109","0209","0309","0409"},A1)),"Exis t","Cannot find") -- Jacob "Jen_T" wrote: I was curious if there is a formula that I can use to check if a cell contains any of the values below? "Q3", "0308", "Q#3, "0408AU", "0408SL, "0408", "0109", "0209", "0309", or "0409" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function needed
What if the cell value ,text, has other tect included, is there a way to
check if the cell value contains the text in the formula below? "Jacob Skaria" wrote: Try =IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU","0408 SL","0408","0109","0209","0309","0409"},A1)),"Exis t","Cannot find") -- Jacob "Jen_T" wrote: I was curious if there is a formula that I can use to check if a cell contains any of the values below? "Q3", "0308", "Q#3, "0408AU", "0408SL, "0408", "0109", "0209", "0309", or "0409" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help needed with a function | Excel Worksheet Functions | |||
| IF, AND, OR Function help needed | Excel Worksheet Functions | |||
| Help needed with IF function | Excel Worksheet Functions | |||
| function needed | Excel Worksheet Functions | |||
| Help Needed With - If-Function | Excel Worksheet Functions | |||
Linear Mode
