You can use the following formula to check if a cell value exists in another sheet in Excel:

=NOT(ISERROR(MATCH(A2,Sheet2!$A$2:$A$13,0)))

This particular formula checks if the value in cell **A2** of the current sheet exists in the range **A2:A13** of **Sheet2**.

If it does exist, then the formula returns **TRUE**.

Otherwise, it returns **FALSE**.

The following example shows how to use this formula in practice.

**Example: Check if Cell Value Exists in Another Sheet in Excel**

Suppose we have the following sheet named **Sheet1** in Excel that contains information about team name and points for various basketball players:

And suppose we have another sheet named **Sheet2** that contains information about team name and assists for various basketball players:

Suppose we would like to check if each name in the **Team** column of **Sheet1** exists in the **Team** column of **Sheet2**.

To do so, we can type the following formula into cell **C2**:

=NOT(ISERROR(MATCH(A2,Sheet2!$A$2:$A$13,0)))

We can then drag and fill this formula down to each remaining cell in column C:

Column C returns either **TRUE** or **FALSE** to indicate whether or not the corresponding name in the **Team** column exists in **Sheet2**.

For example, we can see:

**Mavs**does not exist in**Sheet2**, so the formula returns**FALSE**.**Spurs**does not exist in**Sheet2**, so the formula returns**FALSE**.**Rockets**does not exist in**Sheet2**, so the formula returns**FALSE**.**Kings**does exist in**Sheet2**, so the formula returns**TRUE**.

And so on.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

How to Check if Range Contains Specific Value in Excel

How to Check if Cell Contains Text from List in Excel

How to Calculate Average If Cell Contains Text in Excel