Sorting based on selection. is this possible?

[sssb2000]

hello everyone,
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?

 

[sssb2000]

any thoughts?

 

[sssb2000]

unfortunately, i won't be able to use VBA because of support issues....and i haven't been able to figure out how to do this using a formula....

 

[sssb2000]

bump to top

 

[sssb2000]

have i explained my problem clearly?
i read it a few times and i think it's clear.....if anyone has any questions, i'd be happy to elaborate.