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