I have just used MATCH and VLOOKUP to match cells from two lists that contain the same words.

if I had the word "peter" in one list, I would match it with for example www.adfaf.com/peter

But how do I omit a string like "http://", so that "http://" would not be registered by the match function.
So that "http://www.abcdefg.com" would not be matched with for example "http://www.gfedcba.no"

Should I insert anything into this formula?

=MATCH("*"&LEFT(A1;4)&"*";Sheet2!B:B;0)