Problem i have
1 Execel file 2 sheets

SHeet 1 has 1900 lines of data
Url File Names going down in Row A

hello.htm
hell2.htm
444.htm


Sheet 2 has 2100 lines of data
Row A
Same but this time only part of the data and sometimes full
hello.h
hell2.htm
444.ht

Which means people missed putting files into the excel file
What i need to do is do some type of if or match function so that if

A1:A1905 = Matches or part matches Sheet 2 A1:A2100 then it displaces
the word match or no match in the sheet 2 file some where


Any help would be great