Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, …
Lookup and reference functions (reference) - Microsoft Support
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.
Display the relationships between formulas and cells
When checking formulas, use the Trace Precedents and Trace Dependents commands to display the relationships between these cells and formulas.
Create or change a cell reference - Microsoft Support
Make it easier to create cell references between worksheets and workbooks. The command automatically pastes the correct syntax for you. Click the cell that contains the data you want …
How to avoid broken formulas in Excel - Microsoft Support
The fix is to either move the formula to another cell, or change the formula syntax to one that avoids circular references. However, in some scenarios you may need circular references …
How to correct a #REF! error - Microsoft Support
When you use explicit cell references like this (where you reference each cell individually, separated by a comma) and delete a referenced row or column, Excel can’t resolve it, so it …
INDIRECT function - Microsoft Support
Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a …
VLOOKUP function - Microsoft Support
Use the VLOOKUP function to look up a value in a table. There are four pieces of information that you will need in order to build the VLOOKUP syntax: The value you want to look up, also …
Switch between relative, absolute, and mixed references
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. …
Using structured references with Excel tables - Microsoft Support
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.
How to use cell references and defined names in criteria in Excel
In Microsoft Excel, criteria can be set by typing the exact value that is desired in the criteria cells, or by using cell references or defined names. Important: Quotation marks must be used. …