This is the third in a five book series of Screenbooks that introduces some of Excel's most powerful features.

Here is our sample spreadsheet again. This time we want to fill in column E.

Column E is more of a challenge than was column D. We want to again look in column B and find the product name. Then we want to look in the second table (The Unit Price table). Only this time, we must a supply a second number, the number of Units sold (column C) because the Unit Price depends on how many units were sold.