insert text in fields (possibly mulitple) if certain conditions met

Please help.

I have attached a spreadsheet template that we use to track deliveries into our warehouse and the supplier's performance. The sheet is manually completed and records delivery issues; comments and scores suppliers accordingly. This is used by more than one department.

We have agreed exceptions for certain suppliers - certain standards that they do not have to meet. I need an easy and automatic way of showing the agreed exceptions when the spreadsheet is completed.

Supplier's names are on a drop down list, so ideally, when a supplier's name is selected, the list of delivery issues will adjust so the agreed exceptions for that particular supplier will be clear. Ideally, the magic trick will insert an N/A into the fields as applicable.

However, I have no clue if this can even be done.

We have approx 75 different supplier names (and this list can grow), and currently 14 approved exceptions -some suppliers have no agreed exceptions, so all fields could apply to them; others have one or more agreed exceptions. We are currently checking manually which is extremely time consuming. There has to be an easier way.

I muddle my way through things like this, but this one has got me stumped. No idea how to even begin.

If anyone can assist with this I would be very grateful.

Many thanks in advance

Jen