MATCH function | Microsoft Support
The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. …
Look up values with VLOOKUP, INDEX, or MATCH | Microsoft Support
Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This …
Look up values in a list of data in Excel | 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 …
Use Excel built-in functions to find data in a table or a range of ...
Summary This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in …
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 …
VLOOKUP function | Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel …
Create a relationship between tables in Excel | Microsoft Support
Have you ever used VLOOKUP to bring a column from one table into another table? Excel also includes a built-in Data Model that …
Excel functions (by category) | Microsoft Support
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function …
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 …
Excel functions (alphabetical) | Microsoft Support
A complete list of all Excel functions in alphabetical order.
Create a fuzzy match (Power Query) | Microsoft Support
Fuzzy matching is only supported on merge operations over text columns. Power Query uses the Jaccard similarity algorithm to …