| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check if a cell contains text compared to a range of cells
Sorry, think I mis-read it earlier ..
Put this in C1, array-enter the formula by pressing CTRL+SHIFT+ENTER (instead of just pressing ENTER): =INDEX($B$1:$B$4,MATCH(TRUE,ISNUMBER(SEARCH($B$1:$ B$4,A1)),0)) Copy C1 down to the extent of data in col A. This will return the results that you seek, -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "GD1226, Captain Ahab, manface" wrote Thanks for the response. I tried that formula and it returns: C1: Baseball C2: Footbal C3: Soccer C4: Golf C5: <blank C6: <blank Basically, it's returning the base comparison items instead of looking it up and finding which to print. Any other ideas? I really appreciate the help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) | |||
| How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
| How do I get Excel to display a range of cells with a check box? | Excel Discussion (Misc queries) | |||
| Check if cell contains certain text | Excel Worksheet Functions | |||
| Check to see if cell data is within a range | Excel Worksheet Functions | |||
Threaded Mode
