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.
MIGR_CarlRas One last try. See attached file as I don't like to work in the on-line version.
EXACTLY! 😄
But how does your formula differ from mine?
(See my first post)
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?