Retrieving information: use of lookups and index match
Some of the most important formulas within Excel are those that allow us to retrieve information.
Download the resources to get an in-depth overview of lookups and index match: you will find a sheet explaining how the formulas work and a set of exercises complete with solutions.