Confused look up match function

Toryo0306 Straight-forward VLOOKUP will match 17 out of 67 unique industries in the long list. Standard Fuzzy matching in power query will find 19 matches. So, not much of a gain IMHO. Lowering the "fuzzy threshold" will slightly increase the number of matches, but with a risk of incorrect matches. 

Your real challenge lies into mapping the remaining 50 unique industry references from the long list that do not exactly match one from the shorter list. With reference to the video, you need a translation table telling Excel what to match with what. For example, "Consumer Electronics" could be Consumer Goods, Computers & Electronics or perhaps even Retail. Another example is "Hospitality, Travel & Leisure". Would you match it to Hospitality or Travel? You have to tell Excel. It can't be the other way around. Once you have done that, you can apply VLOOKUP (or XLOOKUP if supported in your Excel version) to all your 976 rows of data and attach the correct overall industry name to each of them.