VLookup or IF issues

Hello,
I am trying to figure excel formulas out.
What I would like is to put an x in a column and have the 3 cells next to it show up in another area of the sheet.

See picture:
I would like to put an "x" in O2 and have L2, M2 and N2 show up in A4, B4 and C4. And to be able to do that with the whole column, wherever I put the "x", the 3 colums to the right show up in A4, B4 and C4.

Is this something that can be done with Excel Formulas?

Thanks in advance for the help.

ScreenHunter_107 Feb. 02 13.28.jpg

In A4

=IFERROR(INDEX(L$2:L1000,SMALL(IF($O$2:$O$1000="x",ROW($A$2:$A$1000)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

Enter with CtrL+shift+Enter

Drag across to column C

Drag down as many rows as required

Originally Posted by Olly

In A4, enter:

Formula:

Please Login or Register  to view this content.

Copy and paste to B4:C4.

This will return the values in columns L:N for the first row with an x in column O.

What did you want to happen if you have more than one x in Column O?

Well that works great. I will only have an X in only one place so I dont need it to do anything if there are two Xs.

Thank you very much.

Originally Posted by JohnTopley

In A4

=IFERROR(INDEX(L$2:L1000,SMALL(IF($O$2:$O$1000="x",ROW($A$2:$A$1000)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

Enter with CtrL+shift+Enter

Drag across to column C

Drag down as many rows as required

Thanks for the help but the post above works fine and I tried this one and its abit over my head lol.

Sorry: misinterpreted your post!

Mine allowed you to put multiple "x" s in column O and would list them all

Originally Posted by Olly

In A4, enter:

Formula:

Please Login or Register  to view this content.

Copy and paste to B4:C4.

This will return the values in columns L:N for the first row with an x in column O.

What did you want to happen if you have more than one x in Column O?

I was wondering if there was a way to just make the formula check for "x" in a certain range of colums... for example from O2 to 027?

You could change to

=IFERROR(INDEX(L2:L27,MATCH("x",$O2:$O27,0)),"")

Any reason for the restriction?

Originally Posted by JohnTopley

You could change to

=IFERROR(INDEX(L2:L27,MATCH("x",$O2:$O27,0)),"")

Any reason for the restriction?

Fantasitc! Works like a charm. Thanks Again