Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
网页Use 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.
LOOKUP function - Microsoft Support
网页The LOOKUP function vector form syntax has the following arguments: lookup_value Required. A value that LOOKUP searches for in the first vector. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value. lookup_vector Required. A range that contains only one row or one column.
Look up values in a list of data - Microsoft Support
网页Look up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned. Use the VLOOKUP, HLOOKUP, INDEX, MATCH, and OFFSET functions to find related data in rows and columns in Excel.
Create custom functions in Excel - Microsoft Support
网页Instead, Excel provides you with the ability to create custom functions, which are explained in this article. Creating a simple custom function. Using custom functions. Understanding custom function rules. Using VBA keywords in custom functions. Documenting macros and custom functions. Making your custom functions available anywhere.
UNIQUE function - Microsoft Support
网页The UNIQUE function returns a list of unique values in a list or range. Return unique values from a list of values. Return unique names from a list of names. An array can be thought of as a row or column of values, or a combination of rows and columns of values.
Transpose (rotate) data from rows to columns or vice versa
网页If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.
Repair an Office application - Microsoft Support
网页If a Microsoft 365 application such as Word or Excel isn’t working correctly, sometimes restarting it will fix the problem. If that doesn’t work, you can try repairing it. When you’re done, you might need to restart your computer. The steps to access the repair tool vary depending on your operating system.
Date and time functions (reference) - Microsoft Support
网页Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
Use conditional formatting to highlight information in Excel
网页Use conditional formatting to highlight information in Excel. Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.
Find or replace text and numbers on a worksheet
网页Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else.
INDIRECT function - Microsoft Support
网页How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.