Entering the Tutorial Data
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
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.