Index & Match multiple cells from sheet1 in sheet2 and output relative cell in sheet2

Hi all, I've searched everywhere and tried tons of formulas to get the output I need. Can someone help me?

I have a row of data in Sheet1:
In Cell P2 I have United Kingdom, In E2 I have ABC123, In C2 I have the formula.
In Sheet2, I have many rows of data... One of the rows will have matching data I am looking for.

What I would like to do is, Lookup the value of P2 from sheet1 in sheet2 column H and if found, in the same row Lookup E2 from sheet1 in sheet 2 column DU, if there is a match then output the relative value from Column DN from the matching row in Sheet2.

Thanks

suppose the data have entered inrows 1 to 100 in sheet2
try this array formula (you should hit CTRL+SHIFT+ENTER at the end of typing formula)

=index(Sheet2!DN1:DN100,match(p2,if(Sheet2!DU1:DU100=E2,Sheet2!H1:H100),0))

Thanks for the replies, I have now managed this by using the example provided by rsdoost.