Entering 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 F2
- Enter the second range into cells D5 to F11
Rows 3 and 4 are left blank in order to accommodate the array 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 are available in this Basic Excel Formatting Tutorial.
