Forum Discussion
XLOOKUP
MIGR_CarlRas One last try. See attached file as I don't like to work in the on-line version.
So, you wan the part that you chopped off from the URL, but without the last slash? If so, try this:
=SUBSTITUTE(RIGHT([@URL],LEN([@URL])-LEN([@[Parent_URL]])),"/","")I believe I entered in into your online file.
That is one way of doing it, but unfortunately this isn't sufficient in my case...
Basicly, what I want is a formula that looks in col. C to find a match in col. A and then returns the value of col. B (if there's a match to be found)
Does that make sense?
MIGR_CarlRas Not really. Sorry. What you have in column C will always be part of what's in column A on the same row and possibly on other rows as well.
In your sample file the text string "https://www.example.com/" from column C will be found on every row in column A. Which value from column B would you want to return in column D then?
I need [category_name] for the parent URL's based on the static data in col. A and B.
If a cell value in col. D matches a cell value in col. A, I want the value of col. B.
So, for instance in my sample sheet C5 = A2. I then want the value of B2 in cell D5
MIGR_CarlRas One last try. See attached file as I don't like to work in the on-line version.