[Help] Lookup with Multiple Criteria

Hi!

I need some help with looking up with multiple criteria, the reason for that is I need to use data from a pivot table with some lookup formula that considers 2 values (City and Product) in order to build a 'dynamic dashboard' with tables.

It's quite hard to explain it by text, so I'll do my best using images:
Image 2 (lookup).png

(image 1) The table on the 'dashboard' sheet is supposed to fill up with information from the Pivot Table located on another sheet.
• The B3 data (City) will be input by the user
• The data on 'dashboard' table (C7:E10) needs to automatically filled depending on the B3 and pivot table data
Image 1 (database).png

So.. I tried to use INDEX MATCH, INDEX MATCH-MATCH with no avail