Hoping for some quick help on a time-sensitive project...
I have attached a spreadsheet that illustrates what I'm trying to do. On Sheet1, I have a list of groups in column A. In columns B-E, there are one or more "terms" associated with each group from column A.
~ VOLT / AMP / HP / HORSEPOWER
On Sheet 2, I have a list of text values that may contain one of the "terms' from Sheet 1. What i need is a formula or routine to return the Attribute Group from Sheet1, depending on which row the term match is made.
Example: for attribute, "ATTR_INCOMING_VOLTAGE", the formula should return the value of "ATTR_GROUP_PROD_DATA_POWE
R" because "VOLTAGE" is found in table row 12.
I've tried building an array formula using INDEX/MATCH, but wasn't able to figure out how to search the array of search terms against the attribute name.
I'd prefer a Formula solution, but VBA is workable.