vlookup to search for the correct charge

Hello i have attached a work book (example) i need it to look at the number of days in the box labled days on cover then get the relevant percentage and take that away from the premium in the box labelled premium and finally show the figure in the pro rata charge box.

thank you again guys

example.xls