Auto select multiple drop down menu base on the info I entered on a specific column

[juno612]

So tired to work day and night for it, lack of sleep is killing me . Hope you guys can help!!!

Subject: CSV product upload
Problem: Too time consuming to select categories and attributes one product at a time
Attribute Definition: A left side sorting menu on ecommerce website Example: Color - Blue, Green, Yellow or Length - 10" to 15", 16" to 21", 22" to 30 and above
Seeking Solution: Manually type a good description on the Product Title Column, then the categories and attributes drop down menu will be automatically select based on the Product Title Column.

Please see attachment for sample. Since the forum doesn't allow me to upload Macro file, therefore, the drop down will not work. Let me know if you would like to see the Macro version, I can email it to you or put it in my dropbox for you.

Hope you guys can help me, it will save me hours of work, truly Appreciate!!!