Categorising rows of data based on the text contained

I've got a large sheet of URL's which I would like to categorise into the content sections e.g. products, downloads etc.

At the moment i'm using a very long IF(ISNUMBER(SEARCH function to say if url contains "/download/" call it "Download", if not, does it contain "Products", if so, call it "Products" etc.

Ideally I'm trying to find some VBA code that I could call through a user function, whereby it searches the selected cell for a list of values on another sheet if it finds that value it returns a specific text if not it searches in a different range and returns another piece of text if it is found.

I've got this piece of code:

Please Login or Register  to view this content.

It starts the job, but doesn't quite achieve what I want. Any help would be much appreciate. Thanks.

hi foxyfmu, wlcome to Excelforum, what is the searched keywords list, can you post sort of sample sheet with original data and result you need to obtain? Do you need UDF only or it can be a macro code?

Hi, thanks!

Sure find attached. Put an example in column C of what would be the outcome. Further explanation on sheet2.

Let me know if you need further clarity.

No it doesn't have to be a UDF, if there's another solution which works just as well.

thanks!
classify_example.xlsx

can the list be repositioned (kind of sorted, first line becomes 16th etc.) or it is important to have initial order of the list?

List can be in any order, so long as it can be repositioned in the future with new data easily

option to make it, please check attachment, press Run

That's fantastic! Thanks very much!

How easy is it to have a third, fourth..set of criteria?

Ah that's amazing thanks so much!

How easy is this to code? Like what level of VBA is this sort of script? Really need to learn more.


Thanks again.

I don't know what level it is, never thought of the level of the code. The code is definitely not complicated in terms of its algorithm. It uses advanced filter and all its actions can be repeated manually.