How to select multiple data points from one entry

[Kazzaw]

Hi,

I have a large amount of data, all which contains duplicate information from different area/sites.

I am looking to have a function where I can input a number (from attached, lets say 165750000 in Column A) and get it to provide me every place this occurs, and the information contained in column E

Example of what I am looking for -

If I enter 165750000 into the spreadsheet (don't care where), I would want a table that would pull information from column E, everytime there is a match (line 10, 62, 136, 280) and display it separately.


The aim of this is, I have multiple unconfirmed sites, however I only have some information for each site (site is column E). By entering multiple numbers from column A, it should eventually spit me out a smaller number of sites that are easier to compare. Rather hard to explain, but I hope it makes sense.

I've attached a demo workbook. The original is 700 lines.

[Bo_Ry]

Put 165750000 in I1

J1
=FILTER(A1:E999,A1:A999=I1)

[Kazzaw]

Thanks! That seems to be doing what I want.

Is it possible to make it more technical? I'm looking up multiple values at the same time, can I enter them all and then have it return a result on the ones entered?

I've re-added my demo book with a bit more of what I'm trying to achieve. I'm basically trying to narrow down the results and then basing the rest of my site info off of geographics

See demo book update, its impossible for 165450000 to be Guthalungra as it doesn't have the same sequence, so that leaves me with 3 other sites

[bebo021999]

In attachment, I put the criteria number in cell K3, then in other cells go down:

Please Login or Register  to view this content.

Drag down

[Bo_Ry]

Try
=SORTBY(FILTER(E1:E999,ISNUMBER(MATCH(A1:A999,I1:I14,))),MATCH(FILTER(A1:A999,ISNUMBER(MATCH(A1:A999,I1:I14,))),I1:I14,))

or with item no.
=SORTBY(FILTER(CHOOSE({1,2},A1:A999,E1:E999),ISNUMBER(MATCH(A1:A999,I1:I14,))),MATCH(FILTER(A1:A999,ISNUMBER(MATCH(A1:A999,I1:I14,))),I1:I14,))

[wk9128]

L3 cell , array formula , copy and drag down

[bebo021999]

Attachment is a new version, after reading your update in #3:
blue cells in column K is list of criteria input one after another, yelow area in column L is for the information of blue cell in column K

[Kazzaw]

Attachment is a new version, after reading your update in #3:
blue cells in column K is list of criteria input one after another, yelow area in column L is for the information of blue cell in column K

Thank you, this appears to be function as I want. I will test on my full data set and let you know how it goes.