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.

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 …

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 …

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.

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 …

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.

Check if a cell has any text in it To do this task, use the ISTEXT function. Check if a cell matches specific text Use the IF function to return results for the condition that you specify. Check if …

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 …

Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use …