Feb-01-2024, 10:21 PM
Hello everyone...
I need to match two huge excel datasets. As a simple example, they look like this:
DataSetA: There is random text, and then a classification.
Text A - Classification A
Marruecos is beautiful in the summer - Tourism
Coca Cola sucks - Food
This computer was bought - Technology
The sun will not shine - Weather
The man is a not really a woman - Social
Who doesnt love cats? - Animals
DataSetB: There is text, but no classification. As you can see, there are words in the Text B than you find in Text A, for example Marruecos, Coca, Computers, Cats and etc. I need a formula or code, that says ,ok if you find in Text B the word Marruecos, go to table A, see where Marruecos is written, and bring me Tourism, and do the same for the following words.
Text B - Classification B
Marruecos is in africa - ?
Coca cola is not healthy ?
Every year there are new computers in the market - ?
Cats kill mice - ?
The number of man increased - ?
The sun is yellow - ?
Marruecos is in africa - ?
I would be really thankful
I need to match two huge excel datasets. As a simple example, they look like this:
DataSetA: There is random text, and then a classification.
Text A - Classification A
Marruecos is beautiful in the summer - Tourism
Coca Cola sucks - Food
This computer was bought - Technology
The sun will not shine - Weather
The man is a not really a woman - Social
Who doesnt love cats? - Animals
DataSetB: There is text, but no classification. As you can see, there are words in the Text B than you find in Text A, for example Marruecos, Coca, Computers, Cats and etc. I need a formula or code, that says ,ok if you find in Text B the word Marruecos, go to table A, see where Marruecos is written, and bring me Tourism, and do the same for the following words.
Text B - Classification B
Marruecos is in africa - ?
Coca cola is not healthy ?
Every year there are new computers in the market - ?
Cats kill mice - ?
The number of man increased - ?
The sun is yellow - ?
Marruecos is in africa - ?
I would be really thankful