LOOKUP or IF: Help please
 

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

LOOKUP or IF: Help please
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Colorado Greenskeeper" wrote:

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

LOOKUP or IF: Help please
 

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

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Colorado Greenskeeper" wrote:

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