lookup if = to 2 values

  • Thread starter Thread starter loscherland
  • Start date Start date
L

loscherland

What formula should i use to give me the quantity for each stor
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 th
quantity per store per sale type. Eg. AAA 001 should return a quantit
of 34 from sheet 2.

Hope i explained that ok.

Thanks in advanc
 
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 qt
 
Back
Top