I have a table with a column that is based on a free-form text description. There are thousands of rows, and each description varies, some end with garbage text and numbers for example.
These cells do contain a keyword that is consistent among each related row, for example:
ID Description Value 0 Left bore A33 $42.00 1 Right bore B2 $100.00 2 Top edge $12.58 3 Bottom edge x3 $87.01
I have another sheet that contains a table such as:
Key Category bore cat-a edge cat-b
I want to search for the key in the second table in each description of the first table, insert the Category in a new column of each of those rows, much like how you would vlookup a value in an array resulting in the following table:
ID Description Value Category 0 Left bore A33 $42.00 cat-a 1 Right bore B2 $100.00 cat-a 2 Top edge $12.58 cat-b 3 Bottom edge x3 $87.01 cat-b
Can anyone guide me here?
Thank you!
Bookmarks