Two conditions return a result from another sheet

[Dumy]

I have a problem how to implement the formula in VBA code to two conditions. Formula partly working and partly not working.
After entering the values in column D, it is necessary that formula, finds two conditions on the second sheet and return the result of the same row.

I use formula

Please Login or Register  to view this content.

Does anyone know a solution or a suggestion for another way
Please see example of attached file

[Dumy]

Is there not here anyone from VBA experts who can help me?

[Dumy]

Since here no help for me
Please moderator, this thread to move to another group Forum

[jindon]

1) To Sheet1 code module

Please Login or Register  to view this content.

2) To ThisWorkbook code module

Please Login or Register  to view this content.

[Dumy]

Hi @Jindon
Thank you so much for your response and the time that you used
My regards

edit:
My apologies, I have to ask another question.
What I need to change the code if instead of column D, I need to enter the values in column K?

Can you write comments for each line of code so that I can modify source. Thank you in advance