Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
WEBUse the table_array argument in a VLOOKUP function. Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.
CELL function - Microsoft Support
WEBThe 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 perform a calculation on it, you can use the following formula: =IF(CELL("type",A1)="v",A1*2,0)
Switch between relative, absolute, and mixed references
WEBPress F4 to switch between the reference types. The table below summarizes how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right. Use absolute or relative cell references in formulas, or a mix of both.
Using IF with AND, OR, and NOT functions in Excel
WEBIn Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
Create or change a cell reference - Microsoft Support
WEBIn one or several formulas, you can use a cell reference to refer to: Data from one or more contiguous cells on the worksheet. Data contained in different areas of a worksheet. Data on other worksheets in the same workbook. For …
Lookup and reference functions (reference) - Microsoft Support
WEBExcel 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.
INDIRECT function - Microsoft Support
WEBReturns 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 formula without changing the formula itself. Syntax. INDIRECT(ref_text, [a1]) The INDIRECT function syntax has the following arguments: Ref_text Required. A ...
Define and use names in formulas - Microsoft Support
WEBBy using names, you can make your formulas much easier to understand and maintain. 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.
Use cell references in a formula - Microsoft Support
WEBIn the formula bar , type = (equal sign). 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 another workbook.
Combine text and numbers - Microsoft Support
WEBWhen you do combine numbers and text in a cell, the numbers become text and no longer function as numeric values. This means that you can no longer perform any math operations on them. To combine numbers, use the CONCATENATE or CONCAT , TEXT or TEXTJOIN functions, and the ampersand (&) operator.
Edit cell contents - Microsoft Support
WEBInsert, delete, or replace cell contents. To insert characters, click in the cell where you want to insert them, and then type the new characters. To delete characters, click in the cell where you want to delete them, and then press BACKSPACE, or select the characters and then press DELETE.