Microsoft Office Tutorials and References
In Depth Information
In this new worksheet, she has both products and models in the same table, and life looks
much better because the final goal seems to be approaching. Bill said to follow the
relationship between products and models, and Michelle tried to do that by adding a column to the
table that uses the VLOOKUP function. She knows that this might not be exactly what Bill
said to do, but she feels that she’s on the right path.
Still, she has the first Excel table loaded without any sales at all. Nevertheless, Bill said to follow
another relationship (which now Michelle knows is a simple VLOOKUP). He said to remember
that sales are stored in orders. It is now time to look for that table.
Michelle searches for something related to sales orders and loads a table called SalesOrderDetail.
After cleaning it up a bit, she ends up with the table shown in Figure 4-5.
FIguRE 4-5 The SalesOrderDetail table.
There is an interesting pattern here. Just as in products, she had the ProductModelID column,
here she has a ProductID column that might be related somehow to the product sold. She tries
the VLOOKUP function again, but this time she searches the product table for the ProductID
column. Moreover, because she has already loaded the product model in the product table,
she can use VLOOKUP to load the product model to the SalesOrderDetail table.
The result is very appealing, as is shown in Figure 4-6.