Excel exercises on LOOKUP FUNCTIONS

This page lists the 14 exercises about Lookup functions in Excel on our website:

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Relatively easy
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values using Poohsticks.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use Vlookup functions in Microsoft Excel 2007 to calculate a total labour bill for different rates.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use Vlookup functions in Microsoft Excel 2007 to quickly calculate car tax bands for a list of vehicles.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Create database lookup functions in Microsoft Excel 2007 to return specific items from a list.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using a Lookup Table To display a curry rating in text.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using a VLOOKUP to display a text message (dog jacket size).

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using exact match look-ups to search on ISBN codes.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using exact match on site codes to return matching data.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use Vlookup functions in Microsoft Excel 2007 to create an enquiry system for a simple database.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using lookup formulae to calculate staff bonuses.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using a lookup table to calculate different discounts.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Average difficulty
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use a vlookup function in Microsoft Excel 2007 to calculate unit costs based on order quantities.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Lookup functions
Level: Harder than average
Courses: Excel AdvancedExcel Business Modelling
Exercise: Using an exact match lookup and HLOOKUP with music exam data.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Lookup functions
Level: Harder than average
Courses: Excel AdvancedExcel Business Modelling
Exercise: Use a Vlookup function in Microsoft Excel 2007 to categorise a list of values - Teletubbies.

Go to exercise ...

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

This page has 0 threads Add post