Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Learn how to use VLOOKUP, HLOOKUP, INDEX and MATCH to look up values in Excel tables. See examples, tips and limitations of each function, and how to use the new XLOOKUP and XMATCH functions.
LOOKUP function - Microsoft Support
Learn how to use LOOKUP function to search for a value in a single row or column and return a value from the same position in another row or column. Compare LOOKUP with VLOOKUP and XLOOKUP, and see examples of vector and array forms.
VLOOKUP function - Microsoft Support
VLOOKUP is an Excel function that lets you search for a value in a table or a range by row. Learn how to use VLOOKUP with examples, tips, and common problems.
MATCH function - Microsoft Support
Learn how to use the MATCH function to search for a specified item in a range of cells and return its position. See the syntax, arguments, examples, and tips for using MATCH with INDEX and VLOOKUP functions.
Look up values in a list of data - Microsoft Support
Learn how to use various functions to look up values in a list of data in Excel, such as VLOOKUP, HLOOKUP, INDEX, MATCH, and OFFSET. See examples, tips, and links to more information.
XLOOKUP function - Microsoft Support
Learn how to use the XLOOKUP function to find things in a table or range by row, with examples and syntax. XLOOKUP can return the first match, the closest match, or a wildcard match, and can handle nested or reverse searches.
Create, load, or edit a query in Excel (Power Query)
Learn how to use Power Query to import and analyze data in Excel. Find out how to create, load, or edit queries, and set default query load settings in the Options dialog.
Using IF with AND, OR, and NOT functions in Excel
Learn how to use the IF function with AND, OR, and NOT functions to test multiple conditions and return different values in Excel. See examples, formulas, and tips for conditional formatting with these functions.
TEXTSPLIT function - Microsoft Support
Learn how to split text strings by using column and row delimiters with the TEXTSPLIT function in Excel. See syntax, arguments, examples, and related functions.
Using Checkboxes in Excel - Microsoft Support
Learn how to insert, remove, and toggle checkboxes in Excel for making interactive lists and forms. Checkboxes have the value TRUE or FALSE depending on their state and can be referenced with formulas.
Count how often a value occurs - Microsoft Support
Learn how to use Excel functions and formulas to count the number of times a value appears in a range of cells. See examples of COUNTIF, COUNTIFS, IF, SUM, and PivotTable methods.