What formula should i use to give me the quantity for each store
depending on sale type for the following table:

Sheet 1 (contains shop info)

Shop Sale Type
AAA 001
BBB 001
CCC 003
DDD 001

Sheet 2 (contains sales info for all stores)

Shop Sale Type Quatity
AAA 001 34
FFF 003 12
CCC 004 24

I need a formula to look up both the shop & sale type to give the
quantity per store per sale type. Eg. AAA 001 should return a quantity
of 34 from sheet 2.

Hope i explained that ok.

Thanks in advance


--
loscherland
------------------------------------------------------------------------
loscherland's Profile: http://www.excelforum.com/member.php...fo&userid=6709
View this thread: http://www.excelforum.com/showthread...hreadid=529145