If D2 appears in F:F, True

[Nanaia]

I'm trying to get a true/false result for an array search and keep getting an $NA result and can't determine why. If the value in D2 appears anywhere in column 'F' I want "TRUE" as a result, if it does not appear in the column I want a false. I've tried multiple different formulas but can't get it to work and can't figure out why. Can any of you assist? I've done this type of formula before but (for whatever reason) can't get it to work this time.

 

[RoryA]

You could use:

=COUNTIF(F:F,D2)>0

 

[Nanaia]

Perfect! Thanks. I was using IF and VLOOKUP and couldn't get the desired results. Yours works! Thank you again.