HLOOKUP formula keeps giving me a value error

Please See attached,

On the the 'MI Totals' tab there are three tables which are linked to the other tab 'MI Weeks 1-10'.

The bottom two tables on the MI totals have basic formula's which are working.

It is the 1st table where i am having problems with this HLOOKUP. In Cell C2 is a drop down menu where you can choose what week to view, in turn it should show you the data for that week. As you can see it is producing a value error.

Any help is greatly appreciated.

Cheers,