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