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.
Watch video INDEX MATCH | multiply the values based on multiple conditions online without registration, duration hours minute second in high quality. This video was added by user Google Workspace Tutorial 24 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 67 once and liked it 6 people.