dynamic formula

In column H i have four possible levels D, L, M, & H. The levels have an associated formula on a sort of database on the same sheet which I can retrieve using the vlookup. however the formula is dependent on the value in column K. but when i use the vlookup the result is static as i drag it down. I know this is not very clear but i will attach the spreadsheet so you can have a look. I need the formula for column R. What I want to achieve is to retreive a formula based on the Demand Level, i then want the formaula to look at the business on books and the come up with the Best Flex rate.