Formulae for Labelling Fields

[midfieldgeneral11]

Good Morning

Hope you can help.

Formulae required for looking at multiple business classes and labelling them in another cell.

I have a spreadsheet has about 10,000 rows. Each row has two fields

Column A = Company Name
Column B = Business Type

Now the Column B is one field which is formulated in two ways.

The first format one cell with each business class separated by a comma.

Marine,Motor Fleet,Specie,Cyber,Hull,Cargo

The second format is one cell with each business class separated by a enter

Marine
Motor Fleet
Specie
Cyber
Hull
Cargo

What I require is a formulae which allows me to update easy to pull information out and group into a relevant business class

The cell has many interpretations of the same business class e.g Motor,Motor Fleet,Fleet,automobile,prestige motors
These would be grouped as Motor Fleet.

So the formulae needs to look in the cell and just mark in column c if it has found a match and label as a generic business class.

I would like the formulae to allow me the user to put a list (Motor,Motor Fleet,Fleet,automobile,prestige motors) and then state these are Motor Fleet

If b2 inlist = Motor,Motor Fleet,Fleet,Automobile,Prestige Motors, motors (this would be labelled as Motor Fleet)

Hope that makes sense.

Thanks I am needing this help.

Simon

 

[midfieldgeneral11]

Anyone help me on this