1. Open the Excel_Homework_Exercises.xlsx workbook

2. Head to the Lookup Functions tab

3. Follow the instructions provided in the worksheet

4. Repeat for the INDEX & MATCH and OFFSET & COUNTA tabs (screenshots below)

NOTE: A homework solution file is available if you get stuck!