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 …

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 …

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 …

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 …

Lists all Excel functions by their category, such as Logical functions or Text functions.

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

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 …

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

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 …

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 …