On Nov 15, 9:48 am, Mrbanner wrote:
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

is the filename unique?
or is it possible, that you have
hello.htm
hello.html
hello.php
hello.php4

If it is unique, a Vlookup should be able to do what you need.
If it is not unique, then it will be a little bit more difficult, to
be
honest i don't have any idea how i would solve the problem.

But if you want to try the vlookup:
Make a new column in your sheet2 with the formula:
=LEFT(A2,IF(ISERROR(FIND(".",A2)),LEN(A2),FIND("." ,A2)-1))
and copy it down

then in a new column in sheet1:
=if(iserror(vlookup(LEFT(A2,IF(ISERROR(FIND(".",A2 )),LEN(A2),FIND(".",A2)-1)),sheet2!
B:B,1,false),"No Match", "Match")

I started with A2 in case you use Titles
change shee2!B:B to your new column in sheet2

hth

Carlo