Google Sheets: Need to find the match number then enter the text

Hi,
Please help me to find the match number in sheet2 if 2 conditions met then enter the text "FOUND" in sheet1

See sample attached

Regards,
tt3

does this work
Look for the number in Sheet1 with Sheet2 column A and that Sheet2 Column D is blank and Column E is NOT blank
=IF(COUNTIFS(Sheet2!$A$2:$A$30,Sheet1!A2,Sheet2!$D$2:$D$30,"",Sheet2!$E$2:$E$30,"<>"&"")=1,"Found","")

change
=IF(COUNTIFS(Sheet2!$A$2:$A$31,Sheet1!A2,Sheet2!$D$2:$D$31,"",Sheet2!$E$2:$E$31,"<>"&"")=1,"Found","")
to
=IF(COUNTIFS(Sheet2!$A$2:$A$31,Sheet1!A2,Sheet2!$D$2:$D$31,"",Sheet2!$E$2:$E$31,"<>"&"")>0,"Found","")

you are welcome

Hi Etaf,
Just find out there should be BLANK if both columns D & E are BLANK. This works on Excel but somehow it doesn't work in google sheet in some cases. Do you know why?

Regards,
tt3

for the D&E blank
=IF(AND(Sheet2!D2="",Sheet2!E2=""),"",IF(COUNTIFS(Sheet2!$A$2:$A$30,Sheet1!A2,Sheet2!$D$2:$D$30,"",Sheet2!$E$2:$E$30,"<>"&"")>0,"Found",""))

Not sure about google sheets , not really used much, but countifs is supported in google sheets
https://blog.coupler.io/countif-and-countifs/

Just checking what version of Excel are you using - you have Excel 2007 in your profile , is that still the version

Perhaps its the "<>"&""
maybe change to "<>" , which you should be able to do in excel anyway
=IF(AND(Sheet2!D2="",Sheet2!E2=""),"",IF(COUNTIFS(Sheet2!$A$2:$A$30,Sheet1!A2,Sheet2!$D$2:$D$30,"",Sheet2!$E$2:$E$30,"<>")>0,"Found",""))

Hi etaf,
Sorry for the late response and the below worked in excel 2007 and I will try in Google Sheet

IF(COUNTIFS(Sheet2!$A$2:$A$31,Sheet1!A3,Sheet2!$D$2:$D$31,"",Sheet2!$E$2:$E$31,"<>"&"")>0,"Found","")

Regards,
tt3