I'm looking to perform what I believe is a "Match" function but not exactly
sure how to achieve it: I am trying to Return receipts of products by
location. My sheet is set-up like this

Location 1 = A8
Product A for Location 1 = D8
Product B for Location 1 = D9
ete etc

Location 2 = A13
Product A for Location 2 = D13
Product B for Location 2 = D13
ete etc

So on for 30 locations

On Sheet2 I select a Location (from a Drop down list) and this I wish to
display the quantities entered by Product as above. Thus my layout is

Location Selected = D6
Product A for location Selected above = F16
Total of Product A for location Selected in D6 = G16

Product B for location Selected above = F17
Total of Product B for location Selected in D6 = G17

etc etc for each product. Thus on Sheet2 cell D6 will change and I'm looking
for a formula that will return the correct product quantities in F17; G17;
H17 etc

Any help appreciated

Thanks