Forum Discussion
Solved
XLOOKUP
Hi there, I'm new here, but I hope you guys can help me 🙂 I'm having trouble with an XLOOKUP-formula... In coulmn A is a list of URL's and in column B is the page name for each URL. I th...
MIGR_CarlRas One last try. See attached file as I don't like to work in the on-line version.
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.
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)