If you have filter function in excel (2019 or 365 version), paste below formula in cell C6
=TRANSPOSE(FILTER(FILTER(Datasheet!B2:O5,Datasheet!A2:A5=DisplaySheet!C3),FILTER(Datasheet!B2:O5,Datasheet!A2:A5=DisplaySheet!C3)<>"","No values found"))