or worksheet function

[snjpverma]

I have a particular alphabetical codes in A1:A26(all different 26 codes), now I put a code in B1 and if that code is matching with the code in A1:A26, then return value to be yes or else no. Thanks for any help

 

[NBVC]

Try

=IF(Isnumber(Match(B1,A1:A26,0)),"Yes","No")