Forum Discussion
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 then use this formula in column C to get the parent of each URL in column A:
=REPLACE([@URL],FIND("@",SUBSTITUTE([@URL],"/","@",LEN([@URL])-LEN(SUBSTITUTE([@URL],"/",""))-1))+1,99,"")
This formula removes the last directory of each URL in column A.
Wonderfull!!!
And here is my issue...
I now want the page name for each of theese parrent URL's in column D...
I'm trying to achieve this with XLOOKUP, but it doesn't seem to work.
My approach is the following:
=XLOOKUP([@[Parent URL]];[@URL];[@[category_name]])
...but all I get is #I/T
Can anyone help me?
Thanks in advance
MIGR_CarlRas One last try. See attached file as I don't like to work in the on-line version.
12 Replies
MIGR_CarlRas Difficult to diagnose based on text alone. First of all, I believe the XLOOPUP formula makes no sense. You are looking up the Parent URL on the current row, in a single cell range, being the URL in the current row and returning the Name in the row. You would want to lookup a single value in an entire table column and return something from another table column if a match is found.
Obviously, no match is (or will ever be) found as the Parent URL is never equal the the URL. Hence the #I/T error (#N/A in English) as a result.
Better to upload an example of your file and indicate the end result you want to achieve.
Riny_van_Eekelen Thank you for your fast reply!
I've made a sample sheet to try and clarify my inqury:
https://carlrasas-my.sharepoint.com/:x:/g/personal/migr_carl-ras_dk/EUPkD_e8_x1JtBLRGu7cUNQBbewR9xcRfR6jAUqF17QiVw?e=pmVEDxHope you can help me 🙂
MIGR_CarlRas Okay, I see the file but what should be shown in column D?
