Forum Discussion
Formula for automatically inputting data based on cells containing specific text
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"...
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.