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)
Bookmarks