Vlookup Returning Values based on Date Range

Hi,
Thought to revive the this thread since my problem is similar.
Attaching the sheet as I want to return the data. Please refer to the attachment as it has all required details.
"Needs the value appearing in column G, if the value in A5 is (less than F5, then return G5), if its equal or more than F5 but less than F6, then return G6), if its equal or more than F6 but less than F7, then return G7 ) and so on……."