Microsoft Excel Vlookup function to assign discounts based on difference between two dates

[wog200]

i love you so much :) you helped me pass my assignment thank you sooooooooooo Muchhhhhhhhh damn tafe IT course =\

[hipchik1]

I enjoyed the tutorial, this is similar to what I am needing to do, but one question is, the fees are different as I have a column with different course types with different course fee amounts. So how do I use VLOOKUP to determine the discount for the different fees, using the scroll down? Or can it be done like that? I have 9 columns with the information and the 11th and 12th column is the table with delay days and %