Printing the adjacent value of matched cell

Hello Sir,


I was stuck into finding the value of matched column next cell value,


Here is what my question actually is

Hello,
I have 2 columns in sheet A,I have another 2 columns in sheet 2
I wanted to match Sheet 1:cell1 with sheet2:cell(1 to N)
and sheet1:cell2 with sheet2:cell(1-N) (only if both conditions are true) then do
and if matched will display what ever is present in sheet2:cell(Matched column) in sheet 1:E1
I am unsure to what to add value of match string
I have used the formula below
=IF(B20=Sheet2!$D$1:$D$100, IF( C20=Sheet2!$E$1:$E$100,Sheet2!$F$1:$F$100,G20),G20)
But its prinitng right data if data matches in the same numbered column in both the sheets.
Means its printing Sheet2:C3 (if Sheet1!A1=Sheet2:A1 and Sheet1!B1=Sheet2:B1)
and not printing the matched records based on finding column in sheet2.

I would be nice if u shed some knowledge on the Same,

Thanks in Advance