M
Mrbanner
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
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