If cells contain specific values from a list Do This, if not Do This.

Assistance please - if one value in a range of cells matches another value in another range, how can I get my IF formula to depict this?

=IF(J9:AN9=Guide!A7:A29,"Related?","")

If a user selects any value in J9:AN9 that matches my list in Guide!A7:A29 DO "Related", otherwise ""

Thanks
Sambo

Hi ,
Sample work book.

Punnam

=IF(SUM(INDEX((COUNTIF(J9:AN9,A7:A29)>0)*1,0))>0,"Related","")
try this formula

Spot On nflsales. Many Thanks!