I am trying to set up a macro to do the following.

I need to type in the date, the plant, and mix type and have a result of
tons show up.
IE:
B8=date D8= plant H8=mix type J8=result

B8=12/2/09 <~~~Enter this
D8=Groton <~~~Enter this
H8=9.5 <~~~Enter this
J8=600 <~~~Return this (answer)

Search area looks like this
A B C D
12/2/09 Montville 12.5 400
12/2/09 Groton 12.5 500
12/2/09 Groton 9.5 600
10/22/09 Danbury 19.0 700

I hope this makes sense. Any help would be greatly appreciated.
I am not looking to autosum. I am only looking to retrieve the tons
produced from that particular day, plant, and mix type.

Thank you in advance