Thank you for any help you can provide I will try to be as detailed as I possibly can be..
On My spread sheet, I have 3 tabs at the bottom listed as "Main Page" "DP Schedule" & "SpreadValues"

The "Main Page" looks like this

Column A = Customer Name
Column B = Contract
Column C = Basis @ Delivery
Column D = Basis When Sold
Column E = Date Product Was Delivered
Column F = Date Product was Sold
Column G = DP Charges That Occurred
Column H = Accumulated Spread Value
Column I = Gain/Loss

Sheet "Main Paige" Column E, represents "Date Product was brought in"
Sheet "Main page" Column F, represents "Date Product was sold"

Sheet "Main Page" Column G, represents "DP charges that Occurred"

-This column needs to be calculated based off of sheet2 renamed as
"DP Schedule"

-Basically, at each facility, the DP charges can vary. Some plants might charge a flat fee if the product is brought in during a certain period of time and then so many cents per month there after... or there will be plants that don't charge a flat fee and only charge so many cents per month.

-So the formula that needs to be entered on the "Main Page" column G, needs to based off the tab listed as "DP Schedule"

-If the date that was typed in on column E on the main page falls between the date range that is typed in Cells B4 & C4 on the DP schedule sheet then that would represent that product will have a flat fee of so many cents, what ever is typed in Cell A4....

-If the date that was typed in on Column F on the main page falls between the date range that is typed in Cells B4 & C4 on the DP Schedule sheet then Column "G's" answer would be what ever is typed in Cell A4.

-If the date typed in Column F on the main page does NOT fall with in the dates typed in Cells B4 & C4 on the DP Schedule sheet, Then Column G's answer should be the flat fee that is typed in Cell A4 plus the value that is typed in Cell D4

The difference between a flat fee and Cell D4, Per/month fee..is the flat fee does not get prorated...so now matter if the product is there 5 days or 20 days it is still what ever value is typed in Cell A4...Now the value that gets typed in cell D4 on the DP schedule sheet is prorated by the days in a month...So if the product was here for 15 days they would only get charged 2 1/2 cents....Ok so my 2 examples go like this...

Cell B4 = 9/15/14 & cell C4 = 12/31/14 & Cell A4 = .15 cents

Ex 1) producer bring us there product on 10/11/14 and then turns around and sells it on 11/18/14, Column G should = .15 cents

Ex 2) producer brings us there product on 10/11/14 and sells it on 3/15/15...Column G should = .15 cents + .05 cents per month prorated = .2750 cents

Ex 3) producer brings us there product on 3/1/15 and sells it on 4/1/15 column G should = .05 cents per month only because it was not brought in with in the date range specified to apply the .15 cents so now the customer will only be charged just the .05 cents per month.

- so the formula has to determine a couple of things...1 is there a flat fee or is it just based off of a monthly rate....if there is a flat fee what is the date range's and then it also needs to be able to pro rate whatever value is typed in cell D4

that is it for the DP charges column G...

Now Column "H" on the main Page

-basically Column H will be based on the sheet listed as Spreadvalues...

-Column H on the Main Page is based off of the dates typed in Column E & F, and then it needs to search the sheet listed as "SpreadValues"

-These Dates in Columns B through E will change every year....so no matter what dates are typed in here it still goes back to the main page and the dates that were typed in...but will represent a Spread Value column F...

Ex.) basically the dates that are typed in on the main page, column E & F. should fall with in one of the rows listed on the Spreadvalues sheet. The date that was typed in for when the "product was brought in" should fall with in the date range listed in column B & C on the Spread Values sheet and then you should be able to follow that line item across and match it up with the Date range listed for the "Date product was sold" and what ever spread value is in that row should be was gets put into Column H on the Main page...That is it

-I hope all this makes sense...Thanks for any assistance you can give me