MATCH function - Microsoft Support
How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
When you're comfortable with VLOOKUP, the HLOOKUP function is equally easy to use. You enter the same arguments, but it searches in rows instead of columns. Using INDEX and …
Use Excel built-in functions to find data in a table or a range of ...
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.
Use Excel built-in functions to find data in a table or a range of ...
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.
Look up values in a list of data in Excel - Microsoft Support
To do this task, use the OFFSET and MATCH functions. Note: Use this approach when your data is in an external data range that you refresh each day. You know the price is in column B, but …
How to correct a #N/A error in INDEX/MATCH functions
When you use an array in INDEX, MATCH, or a combination of those two functions, it is necessary to press Ctrl+Shift+Enter on the keyboard. Excel will automatically enclose the …
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 is best for your needs.
How to correct a #VALUE! error in INDEX/MATCH functions
This topic explains the common scenarios where you encounter the #VALUE! error when using INDEX and MATCH functions together in a formula.
Find and select cells that meet specific conditions in Excel
Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria,—such as …
Find or replace text and numbers on a worksheet - Microsoft …
Match entire cell contents - Check this if you want to search for cells that contain only the characters that you typed in the Find what box. If you want to search for text or numbers with …
Lookup and reference functions (reference) - Microsoft Support
Jun 24, 2025 · 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.