Using VLOOKUP to calculate % using 2007 excel Vlookup In Microsoft Excel.

[iGuest 3]

Using VLOOKUP to calculate % using 2007 excelVlookup In Microsoft Excel.

Hi I had that issue but worked it out between the two dates how to get how many days paid in advance. 

Now I'm having trouble using vlookup to calculating the % discount  to add to  a column titled discount % received. Then after that using the vlookup to  calculate the  discount%  from the actual fees to  end up with a balance due.   I'm stuck, I cant work it out and have tried numerous times.  I have a table 2 columns to the right of my infomration with 1 column with the days in advance and the second column to its right with the . % amounts for days paid in advance.

Help Ive tried using tutorials and you tube videos but all I keep getting is NA in the cell

-question by rochee