Unfortunatly neither of those work - perhaps its due to me using
conditional formatting or dropdown lists?

I don't think so, something else must be the problem, either Rick's solution
or mine should work, maybe your data contain some factor (case, redundant
spaces, etc.) Please post sample data!

Stefi