By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually …

By default, a cell reference is relative. For example, when you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A), and in the same row …

Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.

Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.

A logical value that specifies what type of reference is contained in the cell ref_text. If a1 is TRUE or omitted, ref_text is interpreted as an A1-style reference.

A text value that specifies the name of the worksheet to be used as the external reference. For example, the formula =ADDRESS (1,1,,,"Sheet2") returns Sheet2!$A$1.

A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data, such as when you …

Workbooks links to source workbooks are created in a relative manner whenever possible. This means that the full path to the source workbook is not recorded, but rather the portion of the …

Do one of the following, select the cell that contains the value you want or type its cell reference. You can refer to a single cell, a range of cells, a location in another worksheet, or a location in …

Parts of this article were based on a series of Excel Power User columns written by Colin Wilcox, and adapted from chapters 14 and 15 of Excel 2002 Formulas, a book written by John …