User Profile
MIGR_CarlRas
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: XLOOKUP
Riny_van_Eekelen 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 D53KViews0likes4CommentsRe: XLOOKUP
Riny_van_Eekelen That is one way of doing it, but unfortunately this isn't sufficient in my case... Basicly, what I want is a formula that looks in col. C to find a match in col. A and then returns the value of col. B (if there's a match to be found) Does that make sense?3KViews0likes6CommentsXLOOKUP
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 advanceSolved3.4KViews0likes12Comments
Recent Blog Articles
No content to show