Use vlookup to lookup part of the lookup value in the array

What if you would like to lookup a value and accept any values that are a part of the lookup value?

I have a list of URLs and want to vlookup to see if the base url of these urls occurs in my lookup array.
Example:
Lookup value = www.somewebsite.com/category1/productX
Array value = www.somewebsite.com

So I want to know if the base url of www.somewebsite.com/category1/productX exists in my lookup array.
How would I do that? I can't use wildcards in my lookup value, because by default any lookup value is longer than the corresponding array values.
An additional problem is that the list of base url's in the array contain many different websites ending on .com, .de, .nl, .uk, .eu, etc...
Maybe I could modify the lookup value inside the formula (strip it down to base url before looking up the match in the array) but I don't know how.

Does anyone have an idea on how to solve this?

Goal is a column next to the column with lookup values to tell me if the base url is in the array. So the formula should be in that column.

One way:

=IF(ISNA(MATCH(LEFT(A2,FIND(" ",SUBSTITUTE(A2,"/"," ",3))-1),'Array values'!$A$2:$A$43,0)),"Not ","")&"Present"

=HVIS(ERIT(SAMMENLIGNE(VENSTRE(A2;FINN(" ";BYTT.UT(A2;"/";" ";3))-1);'Array values'!$A$2:$A$43;0));"Not ";"")&"Present"

I succeeded doing it with your proposed formula AliGW! Thanks!

You're welcome. Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.