Seaching a text list using IF

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

Please Login or Register  to view this content.

I thought this may work but does not.

Please Login or Register  to view this content.

This works but there must be a more efficient way of coding it?

Please Login or Register  to view this content.

Having done a bit of reading I've also noted the above statement is limited to 30 logicals. I have some lists that are over this limit so I really need a way of slimming this down. Say my list is from L93 to L125, that is over the limit. I'm sure there must be a way of querying if L36 equals L93 to L125 to return TRUE. Any help greatly appreciated.

Hi,

Does this work for you?

=IF(ISNUMBER(MATCH(L36,L93:L125,0)),"YES","")