The greater than sign and less than sign are used incorrectly.
Please try this formula =IFERROR(INDEX($D$3:$D$13,MATCH(1,($B$3:$B$13<=$G3)*($C$3:$C$13>=$G3)*($A$3:$A$13=$F3),0)),"Not Found")
.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.