Xlookup formula to get result from different worksheet

I have 2 sheets.

Sheet1 has data.
Sheet2 has result.

I have tried to use xlookup without success?

Sample file attached.

Thanks in advance.

Thanks for your reply -that did work on the sample file I attached but there are multiple columns of comments in the data.
I have attached an updated sample file.

Thanks in advance

c2
=INDEX(Data!A:A,LARGE(MMULT(--(Data!$C$2:$F$6=$B2)*ROW(Data!$C$2:$F$6),TRANSPOSE(COLUMN($C$2:$F$2)^0)),1))

copied down and across.

C2=IF($B2<>"",LET(a,AGGREGATE(14,6,Data!$B$2:$B$6/(ISNUMBER(SEARCH(Result!$B2,Data!$C$2:$F$6))),1),I,INDEX(Data!$A$2:$A$6,MATCH(a,Data!$B$2:$B$6,0)),CHOOSE({1,2},I,a)),"")

Copy down from c2

Hi to all!

Another option could be:

PHP Code: 

=LET(f,LAMBDA(r,MAP(B2:B7,LAMBDA(x,LET(c,CONCAT(IF(Data!C2:F6=x,r,"")),IFERROR(--c,c))))),HSTACK(f(Data!A2:A6),f(Data!B2:B6))) 


Check file. Blessings!