Microsoft Office Tutorials and References
In Depth Information
REFER TO A CELL WHOSE ADDRESS VARIES, BASED ON A CALCULATION
Additional Details: In Lotus 1-2-3, this function was the @@ (“at-at”) function.
Additional Details: The argument for INDIRECT can be a named range.
You could create an ad hoc reporting engine by using named ranges and
In Figure 23, a named range has been set up for each column in a report.
Figure 23. You can set up a named range for each column.
Tip: See page 76 for a method to quickly create many range names.
Cell C12 in Figure 24 contains a validation dropdown list that allows a person
to choose any of the headings in A1:F1 (Figure 24).
Figure 24. You can add a
validation dropdown to allow
someone to select a heading.