This is the second of five book set of Screenbooks that provides a look at some of Excel's most powerful features. This Screenbook continues with the same worksheet used in the first tutorial.

This worksheet is incomplete. Let's complete it.

Column D is empty. However, we all the information we need to fill it in. We have a table with the product's unit cost on the right. The Product name is in column B. We just need to look up the product name in the small table on the right, and then we can fill in column D.

But we don't have to do this manually. We can have Excel do it for us.