Microsoft Office Tutorials and References
In Depth Information
Figure 3-23: Using the INDIRECT function with a named range.
You can use the Data ⇒ Data Tools ⇒ Data Validation command to insert a drop-down list
box in cell A16. (Use the List option in the Data Validation dialog box and specify
A2:A13 as the list source.) This allows the user to select a month name from a list; the
total for the selected month then displays in B16.
The workbook with this example is available at this book's website. The filename is in-