One Formula Returns Multiple Rows

[JohnnyVanns]

Hello,

I'm attempting to use one simple query to return all rows that match a given stock number (see file attached). So for I have not been able to accomplish this. Am I overthinking this?

For instance, if I choose stock# 1.1.9.9.1 from a dropdown, all cell values that are connected to it are pulled. Likewise if I choose 1.1.9.9.2, all cell values associated will appear.

It is at this point I plan to apply simple maths to the column values.

stock# name
1.1.9.9.1 stuff0 660 660 451 1771
1.1.9.9.1 stuff1 21 21 14 56
1.1.9.9.1 stuff2 67 67 46 180
1.1.9.9.1 stuff3 1280 1280 875 3435
1.1.9.9.1 stuff4 96 96 65 257
1.1.9.9.1 stuff5 23 23 16 62
1.1.9.9.1 stuff6 0.25 0.25 0.25 0.75
1.1.9.9.1 stuff7 0.25 0.25 0.25 0.75
1.1.9.9.1 stuff8 80 80 54 214
1.1.9.9.1 stuff9 115 115 79 309
1.1.9.9.1 stuff10 52 52 36 140
1.1.9.9.1 stuff11 3 3 2 8

1.1.9.9.2 stuff0 53 53 36 142
1.1.9.9.2 stuff1 60 60 41 161



Thanks!

JV

[alansidman]

What does your raw data look like. It appears that you are only showing us the results you wish to achieve. Upload a sample of your raw data

[JohnnyVanns]

No, that is my raw data... at least a shortened bit of it. There are hundreds of stock numbers. I just need to pull each stock number and corresponding data into a new sheet for further processing. Thanks.