Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching text in cells
Hi,
I have two separate tables. I want to look up a value from table1, match it to a value that's in table2 and return the corresponding contents of a cell in table2. The value I want to match with in table2 is buried with other text in a single cell. How do I "find" the value and return the value I want. For example I want to find this value, 685050-0006 from table1 in the cell in table2 that has this text, "Test of a part, P/N 685050-0006, Serial Numbers 0001104 and 0001090" If I get a match then the expression returns, say, the tech's name. (685050-0006 could be anywhere in the cell). -- AusTexRich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
Getting a total for matching text | Excel Discussion (Misc queries) | |||
Matching Text | Excel Worksheet Functions | |||
Compare cells/columns and highlight matching text strings | Excel Worksheet Functions | |||
How to count matching text | Excel Discussion (Misc queries) |