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, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
XLOOKUP function - Microsoft Support
网页Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
VLOOKUP function - Microsoft Support
网页Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. In its simplest form, the VLOOKUP function says:
Using IF with AND, OR, and NOT functions in Excel
网页Technical Details. Here are overviews of how to structure AND, OR and NOT functions individually. When you combine each one of them with an IF statement, they read like …
HLOOKUP function - Microsoft Support
网页This article describes the formula syntax and usage of the HLOOKUP function in Microsoft Excel. Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.
REGEXEXTRACT Function - Microsoft Support
网页The REGEXEXTRACT function allows you to extract text from a string based on a supplied regular expression. You can extract the first match, all matches or capturing groups from the first match.
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.
Check if a cell contains text (case-insensitive) - Microsoft Support
网页Find cells that contain text. Follow these steps to locate cells containing specific text: Select the range of cells that you want to search. To search the entire worksheet, click any cell. On the Home tab, in the Editing group, click Find & Select, and then click Find.
AGGREGATE function - Microsoft Support
网页Returns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.
LINEST function - Microsoft Support
网页The LINEST function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line.
FIND, FINDB functions - Microsoft Support
网页If you don't want to do a case sensitive search or use wildcard characters, you can use SEARCH and SEARCHB. If find_text is "" (empty text), FIND matches the first character in the search string (that is, the character numbered start_num or 1). Find_text cannot contain any wildcard characters.