INDEX MATCH | multiply the values based on multiple conditions
INDEX MATCH | multiply the values based on multiple conditions.
Our mission is to find the total revenue of the selected fruit during the selected day.
The range of the first INDEX is the entire table.
The range of the second INDEX is the Fruits and Price columns.
We use MATCH to make the fruit name dynamic.
And another one to make the day name dynamic.
