How to find result with multiple column variables

[Hughes5674]

Hello, wonder if you can help. I've got a large data set with multiple column references, and trying to workout the lookups to get the unique result.

Need to find the Analyst when looking in Table 2. For example, Who is the Analyst?

Appreciate any help in advance! Thanks

 

[hagia_sofia]

Hello, one way could be:

=CONCAT(IF(($A$4:$A$6=A13)*($B$4:$B$6=B13)*($C$3:$Q$3=C13),$C$4:$Q$6,""))