Excel 2007 : Help with formula - trying to do a multiple select based on range

Hi there,
I'm trying to create a formula in excel instead of using access to accomplish the following:

1. I have a table with contract information which as start and end dates and rates for a given contractor.
2. I have a table with the dates work by contractor and invoice rates.

I want to lookup the contracted rate based on the date worked.

I've attached the 2 tables in a simple example. The column in green is the one i want populated with the correct info.

Thanks.

Q

Originally Posted by TMShucks

J3: =SUMPRODUCT(--($A$3:$A$7=G3),--($B$3:$B$7<=H3),--($C$3:$C$7>=H3),($D$3:$D$7))

Regards

Awesome Thanks! Works great!