Searching for products and categorizing.

  • Thread starter Thread starter Nicholas1
  • Start date Start date
N

Nicholas1

I've got a tricky one, well for me anyway.

I need to classify a list of products into Hardware and Software. The
trouble is the items can be called Licensed Software, Security Software,
renewal Software, etc... Want I want to be able to do is do an IF formula
that categorizes a cell as Software if the phrase containes Software in it,
does that make sense?

Hardware I'm not to bothered with as if it doesent classify as Software then
it has to be Hardware (as all the software products state so somewhere in the
product name)

Apologies if this is a bit confusing.

Thanks
 
Try the below
=IF(A1="","",IF(ISNUMBER(SEARCH("software",A1)),"Software","Hardware"))

If this post helps click Yes
 
Try this in B2, assuming your data starts in A2:

=IF(ISNUMBER(SEARCH("software",A2)),"Software","Hardware")

Copy down as required.

Hope this helps.

Pete
 
Back
Top