Excel 2007 : Bring value from 2nd table if value in first table is larger

[DLSmith]

Good afternoon,

I am trying to return information from a specific column on a sheet if a column on the first spreadsheet is greater than the value in the 2nd spreadsheet. It's probably easiest to look at the example because I'm not finding a good way to explain.

On the sheet "Open Orders" I want to add a formula to bring over the value in column D "Cust Disc Code" from the 2nd sheet "Order Cost" such that if C1 greater B7 but less than B8 it would populate with the value "F".

If it helps I could add another column in "Order Cost" so that it's referencing a range vs just one value.

I don't know why I'm having such a hard time putting it in words. Hopefully the attachement helps.

Thanks in advance!