Function needed to return specific columns based on input

[TorusTwin]

Hi all,

Sorry for the poor title. I'm having trouble describing this and as a result I haven't had much luck with google searches for what I suspect will be a straight forward function.

If you have a look at the link below you will see my sample data. I want to be able to change the orange cell on the right and have the yellow, green, blue, and red cells automatically populate from the corresponding row.

Is anyone able to help me out with this?

https://imgur.com/a/wSlMQ

Thanks

 

[Peter_SSs]

Welcome to the MrExcel board!

You will get more help if you can provide your sample data in a form that helpers don't need to actually type it out themselves. See my signature block below for more help about that.

Try a formula like this in cell R5 and copy it down to the 3 cells below.

=INDEX(F$6:I$100,MATCH(R$4,A$6:A$100,0),ROWS(R$5:R5))

 

[TorusTwin]

Hi sorry about the image post. I'll make sure to provide the properly formatted data next time around.

I was having trouble with the column section of the Index function. I ended up just manually adjusting it as there were only 4 needed.

=INDEX(F$26:I$335,MATCH(R$2,A$26:A$335,0),1)
=INDEX(F$26:I$335,MATCH(R$2,A$26:A$335,0),2)
=INDEX(F$26:I$335,MATCH(R$2,A$26:A$335,0),3)
=INDEX(F$26:I$335,MATCH(R$2,A$26:A$335,0),4)

Thanks for your help.

 

[Peter_SSs]

Thanks for your help.

You are welcome.