Microsoft Office Tutorials and References
In Depth Information
INDIRECT
A
INDEX range
B
MATCH cell reference
C
MATCH index range
D
MATCH title
E
MATCH
title range
Figure 9.7
The INDEX function with
the MATCH function can
include the return of a
value or of text.
INDIRECT
Based on a text string, INDIRECT returns the reference.
=INDIRECT(ref_text,A1)
The INDIRECT function points to one cell containing a reference to another cell. For example,
you should notice in Figure 9.8 that cell D11 contains an INDIRECT function that uses a text
reference in cell D8 that points to cell E8, so the result is the value found in E8, 5000. On the
other hand, if the Ref_Text argument points to a cell containing a range name, the same
result occurs. For example, if D15 contains text that refers to the range name for cell E15,
then the indirect result is still E15 or the value of 5000.
The reference to a cell that contains an A1 style of reference. This is a
name defined as a cell refence.
REF_TEXT
The logical value that explains which kind of reference is displayed in
the cell.
A1
Search JabSto ::




Custom Search