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 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=pmVEDx
Hope you can help me 🙂
MIGR_CarlRas Okay, I see the file but what should be shown in column D?
Riny_van_Eekelen In column D I would like the category_name for the parent URL's
So, you wan the part that you chopped off from the URL, but without the last slash? If so, try this:
=SUBSTITUTE(RIGHT([@URL],LEN([@URL])-LEN([@[Parent_URL]])),"/","")I believe I entered in into your online file.