can someone help me with this:

i have a database named "data", it looks like this:

date covers rev serv food1
10/01/06 100 dining 5000
10/01/06 50 promo 1000

database is located in sheet 2

in sheet 1 i have this:

date food liquor wine
10/01/06 formula here

i want a formula in the food column that looks in "data" for column "food1"
and brings the date=10/01/06 and the rev<"promo", so it will bring 5000

thanks a lot for your help