Excel Lookup Multiple Columns

Look up value based on a key field and a date that falls between two dates

Formula:
=LOOKUP(2,1/(G:G=A2)/(H:H<=B2)/(I:I>=B2),J:J)