categorizing text with keywords

I have a spreadsheet that i need help categorizing. At the moment it look like...

indeed
indeed.com
bravo indeed
reed
reed.com
advert reed.co.uk
etc etc

I want those to just say indeed or reed. How can i do that?

Please note there are other categories too, i've just used those two as an example

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank John, sorry not used this forum before

Attachment added with before and after.

After is done manually at the moment, so i want to know if there is a formula that will do that automatically

There is no explanation of how the "referral" is derived: it needs a table of "keywords" to be matched and their corresponding "referral" values.

I was just hoping they could be related to a keyword in column b

So would something like this be ok?

Try this ..

=IFERROR(INDEX($H$1:$H$12,SUMPRODUCT(--(ISNUMBER(SEARCH($G$3:$G$12,B3)))*ROW($G$3:$G$12))),"")

Will fail if there are 2 or more "keywords" in B e.g, "indeed Sponsored"


and can you have "career" on its own (rather then "Career Section"/"Career Website")?

That's perfect!

There is just one line that isn't working and i'm not sure why. Its line 7, which says indeed instead of job board.

Change keyword to "Jobserve": make keywords as short as possible e.g Linked not Linkedin

Perfect, thank you for your help on this!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Hi, this is my first consultation on the forum. I found this interesting file that I really needed. I would like to know if it is possible to add the two options that I comment on in the same file that I attach. I use it to code surveys and it would help me a lot to reduce the stressful delivery times. Thank you very much!