Vlookup or Match help?

[sherafyk]

Hello, I've been trying to figure out what formula to use so that when I input it in Sheet1 column B, it looks up the string "USERID1" in column A (the url) and matches it with column A in sheet 2, and the result is the value in column B (clientName)

Sheet1

Column A	Column B
https://example.com/USERID1/randomvalues	=formula for client name
https://example.com/USERID1/randomvalues	=formula for client name

<tbody>
</tbody>

Sheet2

Column A	Column B
USERID1	ClientName1
USERID2	ClientName2

<tbody>
</tbody>

I'd appreciate any and all help. I've been at this for a few hours with no luck. Thank you!

 

[Aladin Akyurek]

In B2 of Sheet1 enter and copy down:

=IFERROR(LOOKUP(9.99999999999999E+307,SEARCH("/"&Sheet2!$A$2:$A$3&"/",$A2),Sheet2!$B$2:$B$3),"")

 

[sherafyk]

Wow, thank you so much. It works perfectly. I was dabbling with IFERROR as well but would never have thought of this. Thanks again!!!

 

[Aladin Akyurek]

Wow, thank you so much. It works perfectly. I was dabbling with IFERROR as well but would never have thought of this. Thanks again!!!

You are welcome.