You must to write the formula:
=Or(IF(F9=($D$9:$D$608),True,False))
Formula 1
True and False without “”
and then, before to press Enter, press Ctrl+Shift+Enter in the cell with the
formula. Excel will automatically add the braces.
{=Or(IF(F9=($D$9:$D$608),True,False))}
Formula 2
If you write the Formula 1 the result will return True if F9 has the same value
that any value in the range $D$9:$D$608 and the other hand this will return
False.