limitation of Match ???

[phiero21]

Is there a limitation of Match function ??

I have around 50 names and when i try to use the match function on them, it gives me unexpected results.....

E.g.

below is the list :

Sumathi Rajan
Lavina Veigas
Mohammed Ansari
Sagar Arora
Pravin Mandlik
Shainaz Khan
Sweeta Monteiro
Pervez Sayed
Shilpa Kudekar
Manjumol Nair
Lily Fernandes
Zeenia Pinto
Prashant Bhat
Sabrina Patel
Sachin Jadhav
Sachin Masal

If i try to use the match function with this list on Shainaz Khan, it gives back 11 (instead of 6)...

 

[goddent83]

You will need to use a match type 0 to get exact returns, then it should work as you require

 

[phiero21]

thanx.

I should have read the complete syntax of MATCH function or sorted the list 1st.