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>
[TD="align: center"]1[/TD]
[TD="align: center"]Description[/TD]
[TD="align: center"]Keyword[/TD]
[TD="align: center"]Route[/TD]
[TD="align: center"]Route I want to Return[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFCC99]#FFCC99[/URL] , align: center"]Large Abrasive Tool[/TD]
[TD="align: center"]Tensile[/TD]
[TD="align: center"]87[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFCC99]#FFCC99[/URL] , align: center"]Small Cutting Scissors[/TD]
[TD="align: center"]Abrasive[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFCC99]#FFCC99[/URL] , align: center"]Difficult Tensile Instrument[/TD]
[TD="align: center"]Cutting[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]87[/TD]
[TD="align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFCC99]#FFCC99[/URL] , align: center"]Random Tool[/TD]
[TD="align: center"]Honing[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"][/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFCC99]#FFCC99[/URL] , align: center"]Small Abrasive Wheel[/TD]
[TD="align: center"]Drilling[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]22[/TD]
</tbody>
[TABLE="width: 85%"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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 | |
---|---|---|---|---|
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Description[/TD]
[TD="align: center"]Keyword[/TD]
[TD="align: center"]Route[/TD]
[TD="align: center"]Route I want to Return[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFCC99]#FFCC99[/URL] , align: center"]Large Abrasive Tool[/TD]
[TD="align: center"]Tensile[/TD]
[TD="align: center"]87[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFCC99]#FFCC99[/URL] , align: center"]Small Cutting Scissors[/TD]
[TD="align: center"]Abrasive[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFCC99]#FFCC99[/URL] , align: center"]Difficult Tensile Instrument[/TD]
[TD="align: center"]Cutting[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]87[/TD]
[TD="align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFCC99]#FFCC99[/URL] , align: center"]Random Tool[/TD]
[TD="align: center"]Honing[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"][/TD]
[TD="align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFCC99]#FFCC99[/URL] , align: center"]Small Abrasive Wheel[/TD]
[TD="align: center"]Drilling[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]22[/TD]
</tbody>
Sheet2
[TABLE="width: 85%"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]