Hello,

What I am trying to do seems like it should be simple but I am having a hard time. All I need is for columns 1 and 2 to show me the contents of A and C respectively anytime column B matches anything in column N.

So from this:

ABCN12x1b1  y2a3  y1a   y3b   x2b   x1a   x3a   

to:

ABCN12x1b1xby2a3yay1a yby3b xax2b xax1a   x3a   

I was able to do this for a single line that matched the first row in N but that was as far as I could get.

I tried mixing XLOOKUP with FILTER but that wouldn’t account for multiple values in N. I tried using CHOOSEROW and XMATCH but I couldn’t seem to get non-adjacent columns to come back.
My example is simplifying; I actually have 25 columns and need 11 of them to show anytime the 13th of them has the same value another, specific cell. There are nearly 5000 rows and I need approximately 400 of them to populate.

Please help?

​Hello,What I am trying to do seems like it should be simple but I am having a hard time. All I need is for columns 1 and 2 to show me the contents of A and C respectively anytime column B matches anything in column N.So from this:ABCN12x1b1  y2a3  y1a   y3b   x2b   x1a   x3a   to:ABCN12x1b1xby2a3yay1a yby3b xax2b xax1a   x3a   I was able to do this for a single line that matched the first row in N but that was as far as I could get.I tried mixing XLOOKUP with FILTER but that wouldn’t account for multiple values in N. I tried using CHOOSEROW and XMATCH but I couldn’t seem to get non-adjacent columns to come back.My example is simplifying; I actually have 25 columns and need 11 of them to show anytime the 13th of them has the same value another, specific cell. There are nearly 5000 rows and I need approximately 400 of them to populate.Please help?  Read More

​