# Find if value in column A contains value from column B ?

Find if value in column A contains value from column B ?

You can try either this solution

```=IF(ISNA(VLOOKUP(<single column I value>,<entire column E range>,1,FALSE)),FALSE, TRUE)
```

Or this solution

`=IF(ISNA(VLOOKUP(<single column I value>,<entire column E range>,1,FALSE)),"FALSE", "File found in row " & MATCH(<single column I value>,<entire column E range>,0))`

Use this easiest way to replace <single column I value> and <entire column E range> along named ranged.

Drag that syntax all the way down the length of the I column in any column you need.

By using  VLOOKUP, although it needs a wrapper function to return True or False. Not to identify it is slow. Alternatively use COUNTIF or MATCH.

From I1 to I2691 use this syntax in column K next to the actual values in column I

```=COUNTIF(<entire column E range>,<single column I value>)>0
=COUNTIF(\$E\$1:\$E\$99504,\$I1)>0
```

As well as you can use MATCH:

```=NOT(ISNA(MATCH(<single column I value>,<entire column E range>)))
=NOT(ISNA(MATCH(\$I1,\$E\$1:\$E\$99504,0)))
```

Try this alternative solution :

```=IF(ISNUMBER(MATCH(I1,E:E,0)),"TRUE","")

```