Ask Experts Questions for FREE Help !
Ask
    deaexcelpadawan's Avatar
    deaexcelpadawan Posts: 13, Reputation: 1
    New Member
    		  
    #1

    Jul 20, 2009, 07:57 AM
    Lookup a single word within a string of text and return a specific word
    HI Everyone!

    I hope your all well!

    I have a bit of an interesting one here,

    In column A there is a list of product names. Within these names there are keywords like perfume or lotion or hair etc

    Is it possible to use formula to look for these specific words within a cell and return a predetermined word.

    My reason for doing this is so I can easily put each product in a category.

    To make it a little more complicated - can we make it so multipule words will return the same category.

    Eg - The category BATH will be used for product names containing; wash, shower gel, shower, bath.

    I have included an example of what I was going for in the attached spreadsheet. I have filled in the categories in column B to show what I was going for BUT that is the column that I'm looking to fill in with the formula.

    Any help that you can give will be much appreiated

    Cheers
    Attached Files
  1. File Type: xls Example1.xls (20.0 KB, 200 views)

Check out some similar questions!

MS WORD loss of text [ 2 Answers ]

I have lost the first five pages of a 30-page document, probably when 'somebody' put an object on the keyboard. I discovered the problem later and can only assume that the 'backspace' or 'delete' was pressed. Can anybody tell me if it is possible to recover the lost text from my hard disk please?...

Why won't text print in Word (Office 12) [ 3 Answers ]

I am trying to print but although text on screen won't show in print preview or print? Pauline :confused:

Word won't print text in bold [ 3 Answers ]

Hi I have been asked to change some information in an existing handbook. I have made the necessary changes. Now I have printed the document but on just one page it doesn't print any text that has been made bold!! If I take the bold off it prints fine but this is a rather important passage and...

'WORD' -- can you save text you highlight [ 5 Answers ]

Into a separate file? Maybe split screen with new file? Would really help me out -- Am reviewing very long pdf file ( svaed as word). Any help much appreciated!

Scanning text into a Word XP document [ 4 Answers ]

My professor needs to have her published economics instructor's manual scanned into a Word document . What scanner and software is capable of doing this? The office has an old HP ScanJet 4C flatbed scanner. Thanks.

View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.