The first column is for the ITEM TITLES of random items and the third and fourth columns are for the CATEGORY ID and CATEGORY NAMES, respectively, that the item could fit into. The second column, ITEM ID, needs to associate a CATEGORY ID to each item by matching a word in the title to a word in the CATEGORY NAME column.
<tbody>
</tbody>
How can I get the ITEM ID column to use the adjacent ITEM TITLE cell to scan the CATEGORY NAME array for a word match. As far as I understand, the excel MATCH function only works with single words. INDEX and VLOOKUP could be used together perhaps.
Any help is appreciated. Thanks!
Also posted
https://www.excelforum.com/excel-fo...ord-in-a-cell-with-that-word-in-an-array.html
| ITEM TITLE | ITEM ID | CATEGORY ID | CATEGORY NAME |
| Bowery Hill Fabric Dining Chair in Antique White | 2342 | Antiques > Architectural & Garden | |
| TR Industrial TR88017 Telescoping Measuring Wheel | 534266 | Art > Fine Art Sculptures | |
| Kidkraft Uptown Espresso ******* | 54336 | Automotive > Parts & Accessories | |
| Powers Collectibles 15763 Signed Basketball Cube | 28754 | Business & Industrial > Hydraulics | |
| Goal Sporting Goods BSSB5085 Baseball Scorebook | 564788 | Collectibles > Advertising | |
| Top Dog Collectibles TDBKTPHOCC NBA Phoenix Suns Chevy Camaro 1-64 Style | 12323 | Home & Garden > *******, Dining & Bar | |
| Business Source Copier Full Sheet Label | 34536 | Sporting Goods > Team Sports | |
<tbody>
</tbody>
How can I get the ITEM ID column to use the adjacent ITEM TITLE cell to scan the CATEGORY NAME array for a word match. As far as I understand, the excel MATCH function only works with single words. INDEX and VLOOKUP could be used together perhaps.
Any help is appreciated. Thanks!
Also posted
https://www.excelforum.com/excel-fo...ord-in-a-cell-with-that-word-in-an-array.html
Last edited by a moderator:
