Checking for unique ID and display data from a table

[Yemjay8]

Hi

I have a data table worksheet which contain some random data mapped to unique id requests as seen in the 'data table' worksheet. This data table is exported from a system and the table would expand downwards(the columns would remain the same) There are cases where this unique system id can be mapped against multiple data (system allows multiple requests under a single unique id for group tracking)
I am planning to share this worksheet with all users, so that they could just check/input their respective System Id to view the current status of their requests only (as seen in Status sheet).
i.e if i am checking a request with system ID 101, i would want to see all data with the same ID in the 'status sheet'.
I tried doing Vlookup with the System ID, but in cases where there are repetitions (example System ID 101 have 3 occurrences) only the 1st one is displayed.

Is there any way this can be done using formulas/Macros?

 

[bosco_yip]

Hi,

See attached file

Regards
Bosco

 

[Yemjay8]

Thanks Bosco. It worked fine with few modifications.
One query though, Can you explain the below formula

=IFERROR(INDEX('Data Table'!B$1:B$100,AGGREGATE(15,6,ROW('Data Table'!B$1:B$100)/('Data Table'!A$1:A$100=$F$3),ROWS($1:1))),"")

 

[bosco_yip]

Thanks Bosco. It worked fine with few modifications.
One query though, Can you explain the below formula

=IFERROR(INDEX('Data Table'!B$1:B$100,AGGREGATE(15,6,ROW('Data Table'!B$1:B$100)/('Data Table'!A$1:A$100=$F$3),ROWS($1:1))),"")

See explain of the formula link :

https://www.ablebits.com/office-addins-blog/2017/02/22/vlookup-multiple-values-excel/

Regards
Bosco