Lookup value in multiple columns

Hi there,

On sheet 2 I have a table with data spread over different columns
On sheet 1 I have a table were I would lik to show certain data per "UniekNummer"

I attached a Test-document

Below more explanation about the Test-document and my wish
I hop you understand my and can help me with this


So I want to lookup UniekNummer WA-AMS1902 000012 on sheet 2

Excel must search on sheet 2 I want to on the row of that UniekNummer if in one of the columns is "BinnenBeoogdeReactieTijd".
If yes, then show "BinnenBeoogdeReactieTijd" on sheet 1 next to the UniekNummer
If no, then Excel mus check on sheet 2 if in one of the columns is "BuitenBeoogdeReactieTijd"

If yes, then show "BuitenBeoogdeReactieTijd" on sheet 1 next to the UniekNummer
If no, then on sheet 1 show "ReactieTijdNogOnbekend" next to the UniekNummer

No file attached

This proposal employs two helper columns which may be moved and/or hidden for aesthetic purposes.
C1 is populated with BinnenBeoogdeReactieTijd
D1 is populated with BuitenBeoogdeReactieTijd
C2:D2 and down are populated using: =SUMPRODUCT((Blad2!$A$2:$A$600=$A2)*(Blad2!$B$2:$D$600=C$1))
B2 and down are populated using: =IF(C2>0,C$1,IF(D2>0,D$1,"ReactieTijdNogOnbekend"))
Let us know if you have any questions.