| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check if a cell contains text compared to a range of cells
I'm trying to see if a single cell contains the same text as any
particular cell within a large range of cells. For instance if i have a column with: (picture this is the first column) Baseball Bat Football Shoes Baseball Glove Soccer Ball Golf Club Turkey Sandwich and a range of cells that have: (b column) Baseball Footbal Soccer Golf I want the C column to return Baseball Football Baseball Soccer Golf #N/A Is this possible? Thanks! -Anthony |
| 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
