Formula for automatically inputting data based on cells containing specific text

[lulupullar]

Hi, I am trying to apply the same data to cells that contain the same text. 

For example in all cells that contain the text "Adrift", "Shree Exports" or "Beads India" then column B will have "10". Then, for all cells that contain "Auburn", column B will have "2". Then for the remaining cells that don't have either of those texts above, their output in column is "3". 

How do i create a formula that does this automatically, without having to input these numbers individually? 

[#2]

@lulupullar The attached workbook demonstrate a solution that could work for you. Created a table with the keywords and their respective values. Then, I search for these key words in the texts in column a in order to return the corresponding value. If a key word is not found, the value 3 is returned.