Data not showing from Combo Box

Hello friends........yesterday i post a problem in forum and i did not fully describe the problem what i want.......so i again post today with brief explanation

i attached a Test file of excel with problem

in the file it contains two i.e. Sheet1 and Sheet2

I create a Searchable Combo box in sheet1.........

In sheet2 contain (3 Column) Account Number, Name of Account Holder and Rupees

In the Account Number (Column) it have 4 accounts number.........but C7 and C9 are the same account number but names are different in "Name of Account Holder" Column.............

My combo box is searchable please enter the account number 1234

Now the problem is in Sheet1 when i insert the account number in Combo box i.e. 1234........it shows 1234 two times (i mean to say that choose 1234 or 1234 above or below) but on account number 1234 it have 2 different name i.e. RAZ and RITA in Sheet2..........

I want when i enter the account number 1234 in combo box.......it gives me two (1234 and 1234) accounts number for choose..........
i want when i choose first 1234 it show the record of RAZ
and when i choose second 1234 it show the record of RITA

This is the problem and how to solve this............

Originally Posted by oeldere

This looks a duplicated question to me.

If so, please mark this question solved, according to the forumrules.

Sir actually i fully explain my problem today's post.............yesterday i did not fully explain the problem............so i created a new post today.........

Originally Posted by oeldere

Then stick by the earlier question, and explain it in that question.

ok sir......now tell me what to do can i edit my yesterday post or how to delete a post..........

Regards