When you work in Excel, you may find yourself needing to compare data. This is especially true with text strings. It’s handy to rapidly compare large volumes of data to find exact text matches. Fortunately, Excel has a built-in formula that does exactly that. Let’s learn **how to use EXACT in Microsoft Excel.**

### How to Use EXACT in Excel

Imagine that you have two columns of data, with each cell containing one or more words. You need to evaluate the data to see if the values in a given row of column A match the values in the same row of column B. Of course, you could do this manually. But if you have a large volume of data, studying it manually takes a lot of time, and is quite error-prone.

This is where Excel’s **EXACT** formula comes in. **EXACT** automatically studies a pair of values and determines whether they are an exact match. If the match is exact, the formula returns the value **TRUE**. If the match isn’t exact, Excel will return **FALSE** when you use the **EXACT** formula.

To use **EXACT** in Microsoft Excel, begin by clicking into an empty cell. Here, we’ll use cell **C1** to compare the values in cells **A1** and **B1** for an exact match.

Begin by typing an **=** sign, which tells Excel that you’ll be inputting a formula. Then, type the **EXACT(** function. So far, your formula reads:

=EXACT(

Then, click the first cell that you want to compare, add a comma, and click on the other cell. Your complete formula should be:

=EXACT(A1,B1)

Hit **Enter** on your keyboard, and Excel analyzes for an exact match. Here, the two cells are an exact match, so Excel returns **TRUE**.

From here, you can copy the formula downward by dragging the corner. Excel will analyze the other pairs. Notice in the case of cells **A3** and **B3**, that the **EXACT** formula is case-sensitive.

As you can see, it’s easy to find matches in Excel, all thanks to the simple, easy-to-use **EXACT** function.