# Excel exercises on ADVANCED LOOKUP FUNCTIONS

 Software: Excel Version: Excel 2010 and later Topic: Advanced lookup functions Level: Relatively easy Courses: Excel AdvancedExcel Business Modelling Exercise: Add an input field to an Excel 2007 model saying what sort of celebrity you are, and use this to calculate income using a lookup formula.
 Software: Excel Version: Excel 2010 and later Topic: Advanced lookup functions Level: Average difficulty Courses: Excel AdvancedExcel Business Modelling Exercise: Use the MATCH/INDEX functions to work out when a drawdown fee is exceeded in an Excel 2007 model.
 Software: Excel Version: Excel 2016 and later Topic: Advanced lookup functions Level: Average difficulty Courses: Excel AdvancedExcel Business Modelling Exercise: Using MATCH and INDEX to find Flight Times.
 Software: Excel Version: Excel 2016 and later Topic: Advanced lookup functions Level: Average difficulty Courses: Excel AdvancedExcel Business Modelling Exercise: Nesting =MATCH inside =VLOOKUP.
 Software: Excel Version: Excel 2016 and later Topic: Advanced lookup functions Level: Average difficulty Courses: Excel AdvancedExcel Business Modelling Exercise: Using MATCH in an Exact Match Lookup.
 Software: Excel Version: Excel 2010 and later Topic: Advanced lookup functions Level: Harder than average Courses: Excel AdvancedExcel Business Modelling Exercise: Show a cash position at the end of every second month for an Excel 2007 model in 3 different ways, using INDEX, OFFSET and INDIRECT.
 Software: Excel Version: Excel 2010 and later Topic: Advanced lookup functions Level: Harder than average Courses: Excel AdvancedExcel Business Modelling Exercise: Use the INDIRECT function in an Excel 2007 model to allow a user to specify a line item and show its total.
 Software: Excel Version: Excel 2010 and later Topic: Advanced lookup functions Level: Harder than average Courses: Excel AdvancedExcel Business Modelling Exercise: When a user looks up a month and week number in an Excel 2007 spreadsheet, show the corresponding value by using MATCH and INDEX.
 Software: Excel Version: Excel 2010 and later Topic: Advanced lookup functions Level: Harder than average Courses: Excel AdvancedExcel Business Modelling Exercise: Create INDEX array functions to show rows and columns from a table for a choice of row/column.

You can search our full list of Excel exercises here, or why not have a look at our other Excel training resources?