Matching Data - Help - Dictionary

[manuel174102]

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

[deanhystad]

How do you know "Marruecos" is an important word to match and not "Africa" or "is"? That is the problem you need to solve. Once you have that, looking up important words is simple.

This is a nice thread discussing finding the subject of a sentence. It is not an easy task.

https://stackoverflow.com/questions/2861...a-sentence