Hi,
I have worksheet1 with rows that contain a sentence. In another worksheet2 I have a table with Keywords that I want to look up in worksheet1 and then redefine them with worksheet2 table. I thought perhaps it would be an IF with VLOOKUP, but I'm not getting the expected result.
For example:
I want to be able to read Row 1(Summary column); compare all the words in Summary to table in Worksheet2(column1-Keyword), then replace with the Defined Value from Worksheet2 to Worksheet1 Catergory. I've tried Vlookup, contain, search, and nothing is working. Any assistance is greatly appreciated.
Worksheet1
<tbody>
</tbody>
Worksheet2
<tbody>
</tbody>
Thank you.
I have worksheet1 with rows that contain a sentence. In another worksheet2 I have a table with Keywords that I want to look up in worksheet1 and then redefine them with worksheet2 table. I thought perhaps it would be an IF with VLOOKUP, but I'm not getting the expected result.
For example:
I want to be able to read Row 1(Summary column); compare all the words in Summary to table in Worksheet2(column1-Keyword), then replace with the Defined Value from Worksheet2 to Worksheet1 Catergory. I've tried Vlookup, contain, search, and nothing is working. Any assistance is greatly appreciated.
Worksheet1
Summary | Category |
LCD is blank | Screen |
Reader is not turning on | Card Reader |
<tbody>
</tbody>
Worksheet2
Keyword | Defined Value |
LCD | Screen |
Reader | Card Reader |
<tbody>
</tbody>
Thank you.