| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup certain text within a cell, PLEASE HELP!
There is a source cell that can contain any combination of AA, BB, HH,
and other 2 letter text separated by commas. For example cell A1 can have "AA, HH" cell b2 can have "AA, BB, HH" I want to set up a formula so that another cell can check cell a1 or b2 and see if "AA" is found in that cell and if it does, to return a "1". If the cell does not have "AA" in it then it would return a "0." Is this at all possible? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Threaded Mode
