simple lookup formula?


Posted by Dan on August 30, 2000 10:29 AM

This should be simple, but I'm suffering form a mental block. Please help me.

I need to look up in a table the availability of an item.
This table contains available quantities for every item in 3 different warehouses.

For example:

I like to see how many pencils are available in warehouse No. 3

The structure of the stock file is as follows:

Item WH Qty

Pencils 01 0
Erasers 01 1
Clips 01 5
Staples 01 2
Pencils 02 5
Erasers 02 4
Clips 02 5
Staples 02 2
Pencils 03 5
Erasers 03 0
Clips 03 5
Staples 03 2



Posted by Celia on August 30, 0100 8:46 PM

Dan
Array formula(Ctrl+Shift+Enter) :-
=SUM((A1:A12="pencils")*(B1:B12="03")*C1:C12)
Celia