Match two columns against other two columns and populate cell

[milo1234]

I would like to match rows D4 & E4, against rows B5 & C5.

If they match, I need cells D5 & E5 to populate cell A5 (API#)

Please can someone help?

[#2]

Hi good day.
You can detail your query a little more please, to be able to help you.
What should appear in D5 if B5 matches D4? and the same for E5.
And how does A5 content come about?

[#3]

By the way, just to clarify and may be useful later.
Technically D4, E4 and so on, they are not rows, they are cells.
1, 2, 3, 4 they are rows. On the other hand, A, B, C, D they are columns.
From the intersection of these rows and columns, cells originate, which we call D4, E4, etc.
I hope this clarification will be helpful to you.

[#4]

@milo1234 

I don't know if I understood it correctly

=IF(ISERROR(LOOKUP(CONCAT($B5:$C5),CONCAT($D4:$E4),2)),"Not found","API#"&ROW())

[#5]

@milo1234 

=FILTER($A$5:$A$7,($B$5:$B$7=D2)*($C$5:$C$7=E2))

cheers