I think I got that far but then ran into problems with the fact that the cell could contain multiple trade classifications (or if I split them across cells it had to check multiple cells) and then do different things depending.
I'm pretty sure it is possible to do what's essentially programming in Excel but I start to whimper. Funnily enough I reckon I could have done it on my old Commodore 64 or Amiga!