Hi All,
I've been looking for days to find a solution to this problem I and to be honest I am shocked no one else has posted it so I am either blind or this is so obvious that no one asks...
Ill attach an excel file to demonstrate the data I have, What I need to do is based on Language, Grade and Week to give a result.
So lets say in Sheet 2 I want to display the result for the following data: Language: English, Grade: A, Week:5
Expected result is: 7
Book1.xlsx
Bookmarks