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.
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 Kitchen 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 > Kitchen, Dining & Bar Business Source Copier Full Sheet Label 34536 Sporting Goods > Team Sports
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!
Cross-posted at https://www.mrexcel.com/forum/excel-...ord-array.html
Bookmarks