Seaching a text list using IF

[BobTheRocker]

I have a list of codes in text form, I want a cell (L35) to return YES it sees a code in another referenced cell (L36) and stay blank if not. The code list is L93 to L100. I can use the IF statement and get it to work using only one cell in the list but not if I use the whole list. Can I use IF to do this or do I need another statement.


This code works

=IF(L36=L93,"YES","")

I thought this may work but does not.

=IF(L36=L93;L125,"YES","")