Data Compiler

Hi All
I have stuck to bring my data from the Sheet called “Test Score” to “Dashboard”
In the sheet called “Test Score” I have the data dump of my certification result.
Mow my criteria is, Once I chose any name from the drop down in “C4” of the sheet called “Dashboard”
That person’s listed details should reflect under the Table-1
Listed details are (Which should pull from the sheet called “Test Score” and reflect in Table-1):-
Certification Name, Test Date, Questions, Correct, Incorrect, Pass / Fail
Apart from this Rating should be reflected as per Rating table in “N23”
Status should be updated manually
In Total the calculation should be based on “Status”, If the Status is selected as “OK” then only it should be calculated in grand total tine.
As an Example, I have filled the table manually how it should look if I choose the “Test Taken By” as “SANTHOSHKUMAR.RAJENDRAN”
Is it possible to deflect the same data with formula

cat.xls

Regards
Arindam

Posted wrong file ? no tab called "Test Score" or "Dashboard"

Sorry for the inconvenience

Cer.xls

In C11

=IFERROR(INDEX('Test Score'!$C$4:$C$1000,SMALL(IF('Test Score'!$B$4:$B$1000=Dashboard!$C$4,ROW('Test Score'!$B$4:$B$1000)-ROW($B$4)+1,""),ROWS($B$4:B4))),"")

Enter with Ctrl+Shift+Enter

For other columns change range $C$4:$C$1000 to required

e.g in E11

=IFERROR(INDEX('Test Score'!$D$4:$D$1000,SMALL(IF('Test Score'!$B$4:$B$1000=Dashboard!$C$4,ROW('Test Score'!$B$4:$B$1000)-ROW($B$4)+1,""),ROWS($B$4:B4))),"")

@ JohnTopley
Thanks for the response.
It's absolutely working as per my expectation.

You are very welcome. Thank you for the feedback.