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 …

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 …

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.

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.

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 …

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

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 these top skills to create your own formulas and functions.