VLOOKUP / PIVOT Tables

Good evening,

My colleague and I have been compiling the attached spreadhsheet for sometime now, and thanks to the great help from contributors on here (notably popipipo and Fett2oo5), we are extremely close to completion.

There is just one sligth snag that we are unable to correct due to our inexperience with VLOOKUP formulas and particularly PIVOT tables.

The problem we have is this, we appear to have several blank values within the Premier drop down menus. If someone is kind enough to help us rectify this, we would be greatly appreciative.

Kind regards.