You could try this

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

-or-

```
=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))
```

you could replace `<single column I value>`

and `<entire column E range>`

with named ranged. That’d probably be the easiest.

Just drag that formula all the way down the length of your I column in whatever column you want.