Try using this formula in cell G1, then copy it to all rows below. It
does a lookup of the value from column F in column D, then checks to
see if it is N/A (meaning not found in column D). The ISNA function
will return true if not found. You want the opposite, hence the NOT
function.
=NOT(ISNA(VLOOKUP(F1,D:D,1,FALSE)))