| Answers Explanation & Hints:
The name of the function in the formula “=INDEX(ProductSales,MATCH(1,($A2=ProductSales[Country])*($B2=ProductSales[Product]),0), 3)” is INDEX.
- ProductSales is the table that we want to get the information from
- MATCH specifies what we want to match from our ProductProfit table to get the information
- 1 is the lookup value
- ($A2 contains the country name and is the value to match = ProductSales[Country] is where to look for the value)
- The * joins the two lookups
- ($B2 contains the product description to be matched = ProductSales[Product] is where to look)
- 0 is the type of match (equals), there is also greater than (1) or less than (-1)
- 3 is the column in which to put the match in the target table
|