Relational Databases

The VLOOKUP recording was done in the charts class because we had time to fit it in. The button below will take you to the correct postion for VLOOKUP task.

The slides show you how to do the VLOOKUP with a named table, but the recorded demo just uses a selection. With the selection you have to lock down the formula with $ dollar signs, but with a named table, you don't need any lockdown $ designators.