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. For example, if the range A1:A3 contains the values 5, 25, and 38, …

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.

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 …

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 Microsoft Excel. You can use different formulas to get the same result. …

Excel 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.

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 easy and efficient.

Have you ever used VLOOKUP to bring a column from one table into another table? Excel also includes a built-in Data Model that lets you create relationships between tables, which can be an alternative to …

Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed …

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 …

A complete list of all Excel functions in alphabetical order.

Fuzzy matching is only supported on merge operations over text columns. Power Query uses the Jaccard similarity algorithm to measure the similarity between pairs of instances. Procedure To open …