Instead of entering values, you can refer to data in worksheet cells by including cell references in formulas.

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.

If you are creating a reference in a single cell, press Enter. If you are creating a reference in an array formula (such A1:G4), press Ctrl+Shift+Enter. The reference can be a single cell or a …

To change the type of cell reference: Select the cell that contains the formula. In the formula bar , select the reference that you want to change. Press F4 to switch between the reference types. …

The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you …

How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.

To include structured references in your formula, select the table cells you want to reference instead of typing their cell reference in the formula. Let's use the following example data to …

The #REF! error shows when a formula refers to a cell that's not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.

You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.

OFFSET doesn't actually move any cells or change the selection; it just returns a reference. OFFSET can be used with any function expecting a reference argument.