I need to perform an operation where Excell will produce a result based on
three criteria. A date, a type, and an area. The date obviously can have
many choices, whereas the type has only three choices, and the area only has
two.

What I'm trying to do:
Be able to open a workbook, enter three criteria (these criteria will be
located in seperate sheets in the same book), and have a completed operation
for that day show up. The completed operation will include specific
products, rates, prices, etc.

Thank you very much