Excel - matching text from another column

[mdro]

I have a spreadsheet that contains a list of items on lease. The list is by item description, but I need an aggregated list by asset class. Most of the items are printers or storage units.

So I would like to create a column that looks for the words "laserjet", "storage", and "GB". If it sees the word "laserjet" then it marks "laserjet." If it sees either "storage" or "GB" then it marks "storage."

If anybody knows a quick way/formula to do this, I would greatly appreciate it.

Thanks!

 

[AnotherHiggins]

If there's just the three conditions, you could use a simple IF function along with an ISNUMBER/SEARCH combo to see if the strings you're looking for are found.

example:
=If(IsNumber(Search("laserjet", A2)), "laserjet", If(Or(IsNumber(Search("storage", A2)),(IsNumber(Search("GB", A2)))),"storage",""))

See Excel's help for details on the arguments for the functions used.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[mdro]

Worked perfectly! Thank you very kindly