VLOOKUP on a date range

A Wet and good morning to you all

I am wanting to use a vlookup function on a sheet, but can not work out how to use a range as the lookup

I have attached a small extract of my sheet

Basically what I want to do is look at the date in column C in the table F - H, and return the value in H, but I do not have the first clue how to use a range to lookup. I have searched many threads but can find none to match, can anyone help please?

Thanks in advance