Excel will present a few options for you to consider. In our example, Excel offers to create 10 different pivot tables that take a look at a number of different angles on our sales data.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

In other words, these references will never change—I will always use the ID to create the lookup, and the database will always be in these cells.