Formula for match value

Hi santosh,

you can share workbook, (if not so secure) so coz I never work on any hindi excel font.. wnat to learn how to match in this case..

in the meanwhile.. you can try this too..

Formula:

=INDEX({"Enter",""},ISNA(MATCH("*"&B2&"*",'Prarup-2'!C:C,0))+1)