LOOKUP or IF: Help please

[Colorado Greenskeeper]

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

 

[Luke M]

Side thought here, but since you have/need a table with all this information
listed, it might be easier to just turn on filters (Data-filter-Autofilter)
and select from the appropriate 3 drop downs the values you want.

 

[Colorado Greenskeeper]

I will try this. The three types and two areas made up six different
worksheets, so I will just combine them all and use the filter.

Thanks