Hi Expert,
I have required these below mentioned PIN Code in one command in single raw IF City equal to Ahamadbad then Pin Code is 380001 Similarly for other city Pin Code Ahamadabad 380001 Delhi 110001 Bangalore 560001 Chennai 600001 Mumbai 400001 Pune 411001 Hyderabad 500001 I have a multiple Pin code as below mentioned City Pin Code Ahamadabad 380001 Ahamadabad 110002 Delhi 110001 Delhi 110002 Bangalore 560001 Bangalore 560002 Chennai 600001 Chennai 600002 Mumbai 400001 Mumbai 400002 Pune 411001 Pune 411002 Hyderabad 500001 Hyderabad 500002 Thanks! Regards Kailash -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com