The formula for the vlookup =VLOOKUP(G4,$A$201:$B$323,2,FALSE)*((G4-15)*F4) then in A201 I put 15 and in B201 I put 0 I filled the column A with a series +.1 and put .04 in column B until I reached 20.1 in column A, then column B changed to .045 and so on. Column G has the moisture and column F has the wet bushels. So the formula finds the moisture listed in the table matching the load moisture (G), extracts the charge (in B) and multiples it times the wet bushels in F If they go by tenths this year this will work if they go by whole points the other formula will work. |