Search multiple keywords

Here is a concept that works. Columns A:B contain the data. The keyword list is in cells O1:O4. If you want a variable length list, we'll have to go to VBA. I assumed you have a fixed list of keywords users can search. If you are going to allow free-form entry, then we'll probably have to toss in an array formula.

Column C is a helper column that compares the keywords selected with and whether it's in column A. It evaluates to TRUE if column A matches one of the key words.

I hope this gets you started off in the right direction. If you need additional help, I suggest including a sample workbook.

Attach a sample workbook (not a picture or pasted copy). 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.