How Do I Match Text Values in Excel?

Matching text values in Microsoft Excel is a common task when working with names, product details, employee records, student lists, and other data. Excel provides several functions, such as EXACT, IF, COUNTIF, MATCH, and XLOOKUP, to compare text values and find matching information.

In this article, you will learn how to match text values in Excel using simple formulas and practical examples. These methods are useful for students, beginners, office employees, and data professionals.

1. How to Match Text Values Using the EXACT Function

The EXACT function compares two text values and returns TRUE if they are exactly the same, including their letter cases. Otherwise, it returns FALSE.

Syntax:

=EXACT(text1,text2)

Example:

Suppose cell A2 contains Excel and cell B2 contains Excel.

Enter this formula in cell C2:

=EXACT(A2,B2)

Result: TRUE

Now, if A2 contains Excel and B2 contains EXCEL, the result will be FALSE because EXACT is case-sensitive.

When to use it: Use EXACT when you need to compare text values and distinguish between uppercase and lowercase letters.

2. How to Match Text Values Using the IF Function

The IF function checks whether two text values match and displays a custom message.

Formula:

=IF(A2=B2,"Match","Not Match")

Example:

Enter the formula in cell C2 and copy it down to compare other rows.

Note: The comparison A2=B2 is generally not case-sensitive. For