Employee Directory Matching
Match a list of badge requests to an HR roster with INDEX and MATCH, then add a two-way lookup that finds each person's allowance by grade and location.
What you will practise: Combine INDEX and MATCH to pull values from a roster, and nest two MATCH functions to look up a table by both its rows and its columns.
Premium
This is a Premium exercise
Premium members can open this exercise and practise it in the spreadsheet.