Co-Authored By:

##### Asked by: Servita Havkin

technology and computing browsers# How do you check if data in one column is in another Excel?

**Example using VLOOKUP**

- Select cell C2 by clicking on it.
- Insert
**the**formulain“=**IF**(ISERROR(VLOOKUP(A2,$B$2:$B$1001,**1**,FALSE)),FALSE,TRUE)”**the**formula bar. - Press Enter to assign
**the**formula to C2. - Drag
**the**formula down to**the**other cellsin**column**C clicking and dragging**the**little“+” icon on**the**bottom-right of C2.

In this way, how do you check if data in one column is in another?

Select **a** blank cell next to **the data**youwant to sum, and enter thisformula=**IF**(ISERROR(VLOOKUP(C2,$**A**$2:$**A**$7,**1**,FALSE)),FALSE,TRUE ), then drag autofill handle down toapply thisformula to **the** cells, **if** it displays TRUE,then**the** corresponding **data** exists in**anothercolumn**, and **if** it shows FALSE,**the**corresponding

**MATCH**function searches for a specifieditemin a range of cells, and then returns the relative position ofthatitem in the range. For example, if the range A1:A3 containsthevalues 5, 25, and 38, then the formula=

**MATCH**(25,A1:A3,0)returns the number 2, because 25 is thesecond item in therange.

In this regard, how do I check if a value is in a range in Excel?

Select a blank cell next to **the value** you wantto**check if** appears in **the range**, type thisformula=COUNTIF($A$2:$A$6,"*"&B2&"*")>0, and drag**the**auto fill handle down to **check**other**values**.

The **Excel ISNA** function returns TRUE when acellcontains the #N/A error and FALSE for any other value, or anyothererror type. You can use the **ISNA** function with theIFfunction test for an error and display a friendly message whenitappears. Test for the #N/A error. A logical value (TRUE orFALSE)=**ISNA** (value)