Forum Discussion
XLOOKUP
MIGR_CarlRas One last try. See attached file as I don't like to work in the on-line version.
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
Mine:
=XLOOKUP([@[Parent_URL]];[URL];[category_name])Yours:
=XLOOKUP([@[Parent URL]];[@URL];[@[category_name]])Your formula has a few ampersands too many. Should have made that clear in my first response. Simply got confused when I saw the file and lost track of your intentions. Sorry about that. But, glad that it is solved now!
- Ahh... I see it now!
Yours:
=XOPSLAG([@[Parent_URL]];[URL];[category_name])
vs.
Mine:
=XLOOKUP([@[Parent URL]];[@URL];[@[category_name]])
But I'm not sure why mine doesn't work? EXACTLY! 😄
But how does your formula differ from mine?
(See my first post)MIGR_CarlRas One last try. See attached file as I don't like to work in the on-line version.