Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If "text" exist within "cell" then TRUE
I cant find a way to look up if a string of text exist within a cell and reply with TRUE or FALSE, such as "if "text" exist somewhere within "cell" then TRUE". I have a list that looks something like: Archetype Skill Dancer Acrobatics, Dance, Seduction Repairman Mechanics, Technology, Security And a cell where I can define an Archetype, such as: A1=Dancer I am trying to create a formula that's something like: If "Dance" exist somewhere in "1 column from the archetype declared in A1", then type the text "Good at dancing" here, else "Cannot Dance" -- JemyM ------------------------------------------------------------------------ JemyM's Profile: http://www.excelforum.com/member.php...o&userid=26945 View this thread: http://www.excelforum.com/showthread...hreadid=467251 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
Not all of the text is visible when looking at the cell. | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |