Hello Excel World!!

Hello Everyone!!.

I have been using excel for more than 2 years and trying to explore new things. I know there are lot of experts who the do magics with excel in this forum. I want witness those magics and one day, i hope i'll get a chance do the magic

I have a query regarding using Vlookup function with Data Validation (Drop down) function.

I have attached the file in which I have a Table having Workers' details of Cheques. The Card No. of the Worker is the Unique Identity for each worker. I have written details of only 2 workers. Other details are Name, Beneficiary, Account No. and Bank.

I want that when I insert the Card No. manually, all the Details should fill in the Rows below automatically. The name of the worker is only one(its repeated but it does not matter coz its is the same), so I get the desired detail filled. But the problem is with the Beneficiary. Each worker has 3-4 Beneficiaries in the given Table. I want to use Vlookup to look for all the values for that particular worker using the Card No. and automatically give a drop down list showing all the Beneficiaries corresponding to that Worker. After getting the Drop down List I will choose the Desired Beneficiary by myself manually through Drop down arrow.

Please help.