What is the name of the Microsoft Excel function in the formula “=INDEX(ProductSales,MATCH(1,($A2=ProductSales[Country])*($B2=ProductSales[Product]),0), 3)”?

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