Thanks a lot CK76. You are genious
I didn't think about match index before. In the excel you attached, it is giving #N/A for Pin code - 110002 for all objects. What can be the reason?