If Value Exists in Column Then TRUE in Excel

Here’s an example of how you can implement a function to check if a value from one column exists in another.

Download the Practice Workbook

5 Methods to Return TRUE If a Value Exists in a Column in Excel

Method 1 – Use a Simple Formula to Find TRUE If the Columns Match

Steps:

• Use the following formula in the first cell of the result column (here, Cell D5).

• You will get TRUE as output if both column values match.
• Use autofill (+) to drag down the formula to the rest of the column.

Method 2 – Return TRUE Using the EXACT Function If Values Match in Two Columns

Steps:

• Use the following formula:

• Here’s our result after applying AutoFill.

Method 3 – Use a Combination of MATCH, ISERROR, and NOT Functions to Get TRUE If a Value Exists in a Range

We have a fruit dataset and we will look for a particular fruit name (from column B) in a column containing a list of other fruits (column C).

Steps:

• Use the following formula:

• You will get the following result if the formula is entered correctly.

Method 4 – Return TRUE If a Value Is Present in an Excel Column Using the Combination of IF, ISERROR, and VLOOKUP Functions

Steps:

• Insert the following formula:

• Here’s our result.

Method 5 – Use the Combination of ISNUMBER and MATCH Functions to Get TRUE If a Value Is Found in a Column in Excel

We want to find any month of column B in the month list of column C.

Steps:

• Insert the following formula:

The MATCH function will look and match the value of Cell B5 in the range C5:C13, and the ISNUMBER function checks whether a value is a number and returns TRUE or FALSE. If the MATCH fails to find, it won’t return a number, so ISNUMBER will go to FALSE.

• You will get the result as follows.