Hey all, looking for a bit of help. I'm starting to read into VBA, but I'm still unsure of when I should use it. Could I find another way to do this using excel functions?

Lets say for example, I have a database, about 2000 rows. Column A is a ID #, and column B is a description. I then have a separate excel sheet, that has only descriptions. I want to scan the database, and paste the ID # in to match the descriptions in the separate excel sheet.

Examples of descriptions:

Tall red 42 car
Small red 42 car
Tall blue 21 truck
Tall red 81 car

There are many shared words between descriptions.

In the database sheet, the description is in one column. However, for the separate search sheet, the descriptions might be broken up so each word has it's own column. I can either format the search sheet so that the descriptions end up in one cell, or write the code so that it searches each column.

My idea for what needs to happen :
Let's us assume I made the search sheet so the description is in one cell.
Break up the description into individual strings.
Search for the first string for every match in the database.
Search for the second string for a match in all the previous matches.
Continue this process until you finish all the strings.
If there was a single complete match, paste the ID# in the search sheet next to the description.
If there was more then one complete match, paste each match ID#, as well as highlight that cell yellow.
If there were partial matches, paste the ID#s and highlight orange. (this step I may get rid of.)
If there were no matches, leave the ID# cell blank, and highlight red.

This would continue until you reached the end of the search terms.

Any advice appreciated.
Thanks.