Suppose I have 1000 data in column A and I want to categorize the column A data in column B. These 1000 data I want make into 4 categories in column B. So what I was thinking if I could have write single formula in column B and drag till the end, the each data cell of column A will fall respective category in column B. Please find the attachment to understand better.
In this sheet I have two columns Keyword and Category.
If any cell containing "paper" or "question paper" or "sample papers" will come under category called Sample Paper in column B.
If any cell containing "syllabus" will come under category called Syllabus in column B.
If any cell containing "book" or "books" will come under category called Book in column B
I can solve this by using Filter in Column A but I want a formula which can be written in column B and drag till the end to get result.
Any suggestion or help highly appreciated.
Thanks in advance.