| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search range of cells for word & return value for use in formula?
Using Excel, I want to be able to type in a word and have a formula that is
"looking" at that cell return a value (true or false, yes or no, 1 or 2) based on whether the word I typed is or is not in an array of cells. I want to then be able to use this value in a formula to print a "yes" or "no". Is there a simple way to do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to return the reference of a range of cells | Excel Discussion (Misc queries) | |||
| search within a range of cells? | Excel Discussion (Misc queries) | |||
| auto filter doesn't return cells containing the custom search wor. | Excel Worksheet Functions | |||
| need formula to search column for a word and return another word | Excel Discussion (Misc queries) | |||
| Excel - Formula Query: Search for and Return Value | Excel Worksheet Functions | |||
Threaded Mode
