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.