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