If statement of an array that retrieves multiple results

Hi there,

I'm creating a project report template and want to pull through multiple results from an if statment.

Example:
Look up column D for anything that is >=5, and list the results in ascending order. The fields that I want to pull through if the results match ">=5" are: Column A, E, F, G

Result to look something like this in ascending order:
R001: ABC EXAMPLE; Mitigation; TEXT B
R002: DEF; Mitigation; aaaa

Excel.PNG

Any help is appreciated.

Thanks
Sooghtac

Excel report.xlsx

Now attached, thanks.