Bill Bisco
Active Member
- Joined
- Aug 8, 2007
- Messages
- 446
Hi all,
Every Keyword has a route associated with it. I want to find out which description contains the keyword and then post the associated route for that keyword .
For example, Abrasive is associated with Route 22. I want to match the Description "Large Abrasive Tool" to the keyword Abrasive. and now in the same row as Large Abrasive Tool I want to post the associated route of the keyword contained within "Large Abrasive Tool" (which is Abrasive) which should be Route 22.
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
Every Keyword has a route associated with it. I want to find out which description contains the keyword and then post the associated route for that keyword .
For example, Abrasive is associated with Route 22. I want to match the Description "Large Abrasive Tool" to the keyword Abrasive. and now in the same row as Large Abrasive Tool I want to post the associated route of the keyword contained within "Large Abrasive Tool" (which is Abrasive) which should be Route 22.
A | B | C | D | |
---|---|---|---|---|
1 | Description | Keyword | Route | Route I want to Return |
2 | Large Abrasive Tool | Tensile | 87 | 22 |
3 | Small Cutting Scissors | Abrasive | 22 | 45 |
4 | Difficult Tensile Instrument | Cutting | 45 | 87 |
5 | Random Tool | Honing | 21 | |
6 | Small Abrasive Wheel | Drilling | 11 | 22 |
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2
<tbody>
</tbody>