Enter the Tutorial Data
The first step in the tutorial is to enter the data into an Excel worksheet.
In order to follow the steps in the tutorial enter the data shown in the image above into the following cells.
- Enter the top range of data into cells D1 to F1
- Enter the second range into cells D4 to G8
Rows 2 and 3 are left blank in order to accommodate the search criteria and the lookup formula created during this tutorial.
The tutorial does not include the formatting seen in the image, but this will not affect how the lookup formula works.
Information on formatting options similar to those seen above is available in this Basic Excel Formatting Tutorial.
Tutorial Steps
- Enter the data as seen in the image above into cells D1 to G8
