Help with formula please!

[sssb2000]

hello everyone,
I'm trying to figure out a formula that will help me accomplish this:

in column A, i have different types of investments......type A through G let's say and they are not in order.
in column B, i have risk titles for each investment type.
in column c, i have probabilities.

In K5, i will put an investment name (for example: Investment C)


is it possible to get all of investment C data sorted and shown in columns F:H?
(when the investment type/name is changed in K5, the table in F:H would change to have all the information from that investment alone)

can this be done using a formula?

 

[Excelestial]

Certainly is. Want to post a small portion of your work?

 

[dannac]

F5 - =K5
G5 - =INDEX(B5:B11,MATCH(F5,A5:A11,0))
H5 - =INDEX(C5:C11,MATCH(G5,B5:B11,0))

May not be best way but should work.

 

[sssb2000]

thanks, but this is not what i meant.

Column A has content like this:

Investment 1
Investment 2
Investment 3
Investment 4
Investment 5
Investment 3
Investment 4
Investment 5
Investment 2
Investment 2
Investment 2
Investment 2

So, if K5 has "Investment 2" in there, i need to have a formula that's smart enough to know that Investment 2 (and related information in column B and C) need to be listed 5 times (since investment 2 is showing up 5 times in column A)