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

try this

=INDEX(C:C,MATCH(D1&E1,$A$1:$A$5&$B$1:$B$5,0))

This is an array formula so you must
Ctrl,shift,enter for it to work

for this example D1 And E1 is your criteria
A1:A5 is shop
B1:B5 is sale type

column C is your qty


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=529145