combining two Index(Match) functions into an IF function

I have two INDEX&MATCH fuctions that return valid results by themselves.  The result is in mm/dd/yyyy format. {=INDEX(Sheet3!C:I,MATCH(1,(Sheet3!F:F=D27)*(Sheet3!C:C="2B1047"),0),7)} {=INDEX(Sheet3...