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
Bookmarks