I have a worksheet showing a column of file names e.g.
XY1234X
XY5678X
XY2468X
XY4321X etc

and another worksheet containing a column of file paths e.g.
I:\Sales\AllUsers\Marketing\115001 - North East\XY1234X
I:\Sales\AllUsers\Marketing\115001 - North East\XY8765X
I:\Sales\AllUsers\Marketing\115002 - North\XY4321X
I:\Sales\AllUsers\Marketing\115003 - North West\XY5678X


What I'd like to do is cross reference them to see if any of the file names appear in any of the paths.

I tried using VLOOKUP by adding a column to the right of the path column with the letter "Y" in it and asking for this "Y" to be returned in the event that the file name appeared in the path but it returned "#N/A" indicating that the data was not found (even though the test Lookup value was definitely contained in one of the paths in the table array).

I'm pretty sure I'm barking up the wrong tree with VLOOKUP and would maybe be better off with an IF function of some kind. Does any one have any ideas, please?