Need help doing a Lookup with a calculated string


#1

I use a formula to extract the base domain from a long URL
e.g.,

LEFT(Link,FIND("/",Link,4+FIND("://",Link)))

which will take something like:

'https://www.networkworld.com/article/3202753/data-center/data-center-startup-offers-compute-colo-at-cell-towers.html

and return the base domain:

'https://www.networkworld.com/

I then want to use that base domain to do a lookup into a table that maps the domain to an actual human readable title of the site, but the Lookup won’t let me use the extracted URL. The formula field where the string manipulation occurs is not offered as one of the options for Lookup.

Help!