How to use the INDEX function in Excel to return a value or reference to a value within a table or range.

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.

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. This article uses …

Note: If you want either the INDEX or MATCH function to return a meaningful value instead of #N/A, use the IFERROR function and then nest the INDEX and MATCH functions within that function. …

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 …

To put a number value in cell G1 (depending on which item is selected in the list), type G1 in the Cell link box. Note: The INDEX () formula uses the value in G1 to return the correct list item. Under Selection …

This new dynamic array behavior can also affect earlier functions that have the ability to return a multi-cell range or array. Below is a list of functions that could return multi-cell ranges or arrays in what we …

This topic explains the common scenarios where you encounter the #VALUE! error when using INDEX and MATCH functions together in a formula.

Use an index column to show the number of a row in a query, which helps when you filter by row position or by a range or rows, and select customize it with a different starting number and increment.

Common functions that could return multi-cell ranges include INDEX, OFFSET, and User Defined Functions (UDFs). A common exception is if they are wrapped in a function that accepts an array or …

Learn these top skills to create your own formulas and functions.