NEVER use that sort of formula with whole columns. It will be VERY slow, as MATCH will look every one of Excel's 1,000,000+++ rows . Instead use sensible ranges.

=INDEX(Sheet1!$D$2:$D$300,MATCH(1,(Sheet1!$H$2:$H$300=G719)*(Sheet1!$J$2:$J$300=R719),0))