Finding the Categories Based on the KeyWords

[Jeevanhr]

Hi i want to find the categories on the Basis of keywords present in the Column A in the Sheet 1, and i am able to get the Categories names in the Column B,but if only one key word is Present in the Column A, But i want in a Different Way. i am Writing the rules in the rules sheet. I want the Result Like this

Sheet 1.

Keywords-----------------------------Expected Result Category
Computer-----------------------------Electronics
hardisk,Computer--------------------Storage Devices,Electronics
Desktop-------------------------------Hardware,Electronics
Laptop,Computer---------------------Hardware
Printers------------------------------- Hardware
Microphones--------------------------Input Device

Rules Sheet

Search_For:-----Category:
Computer---------Electronics
Hardisk-----------Storage Devices
Desktop--------- Hardware
Laptop-----------Hardware
Printers----------Hardware
Microphones Input Device


I am using this code to Find the Categories

Please Login or Register  to view this content.

[karedog]

The trick is to get the string before comma (if there is a comma) in keywords, then the search is performed based on this string like this :

Please Login or Register  to view this content.

[Jeevanhr]

Thanks For Your Reply, i tried your code it searches only the for keywords within the comma and Return the Category, Can it be possible to do like this, if the Multiple keyword present in a column like this
Sheet 1.

Keywords---------------------Expected Result Category1------------Expected Result Category2
Computer-----------------------------Electronics
hardisk,Computer--------------------Storage Devices------------------------------------Electronics
Desktop,Computer------------------ Hardware-------------------------------------------Electronics
Laptop,Computer---------------------Hardware
Printers------------------------------- Hardware
Microphones--------------------------Input Device

[karedog]

You are welcome.

It should be like this :

Please Login or Register  to view this content.

BTW, since you are new, please take a time to learn some rules of this forum here :
http://www.excelforum.com/forum-rule...rum-rules.html

A point of interest will be in this question :
Want to get your question answered quickly?
- Post a WORKBOOK

You will get a better response of forum members if you make it easy for them to help you, i.e. posting a sample workbook will avoid the helpers to retype the data.

[jaslake]

Cross Posted @ http://www.ozgrid.com/forum/showthread.php?t=198726