Whole document tree INDIRECTDescriptionINDIRECT function returns the contents of the cell pointed to by the ref_text string. The string specifices a single cell reference the format of which is either A1 or R1C1 style. The style is set by the format boolean, which defaults to the former. If @ref_text is not a valid reference returns #REF! |