| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup text values
I want to compare one column of text data with another, but not all of the
information is the same. I don't need to know whether the data is exact, I simply want to know if it is alike. Eg. A B Green Apples Apples Juicy Pears Tree If any part of the two cells are the same, e.g. as Row 1 I want to be able to return a value. Is auto filtering the only way to do this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
| Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) | |||
| Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) | |||
| text and values combined in one cel | Excel Discussion (Misc queries) | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
