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 …

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.

These examples use the INDEX function to find the value in the intersecting cell where a row and a column meet. Copy the example data in the following table, and paste it in cell A1 of a new …

You can use the INDEX and MATCH functions together to get the same results as using LOOKUP or VLOOKUP. The following is an example of the syntax that combines INDEX and MATCH to …

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 …

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

When you use MATCH, there should be a consistency between the value in the match_type argument and the sorting order of the values in the lookup array. If the syntax deviates from …

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.

You can use the INDEX and MATCH functions together to get the same results as using LOOKUP or VLOOKUP. The following is an example of the syntax that combines INDEX and MATCH to …

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

These examples use the INDEX function to find the value in the intersecting cell where a row and a column meet. Copy the example data in the following table, and paste it in cell A1 of a new …