Lookup formulae limitations - Please help

[atifmalam]

A B C D
( Reqd Sheet)
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Emp
[/TD]
[TD]302[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Serial[/TD]
[TD]Customer #[/TD]
[TD]Customer Name[/TD]
[TD]etc etc sale, qty, area[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Master Data
A B C D
[TABLE="width: 553"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Emp[/TD]
[TD] Emp Name[/TD]
[TD]Customer#[/TD]
[TD] Customer Name[/TD]
[/TR]
[TR]
[TD]302[/TD]
[TD]CMH1201 (HASAN ALI)[/TD]
[TD]923[/TD]
[TD]A-1 BROST & BURGER FAST FOOD[/TD]
[/TR]
[TR]
[TD]302[/TD]
[TD]CMH1201 (HASAN ALI)[/TD]
[TD]3032[/TD]
[TD]PIONEER BROAST[/TD]
[/TR]
[TR]
[TD]302[/TD]
[TD]CMH1201 (HASAN ALI)[/TD]
[TD]3754[/TD]
[TD]APP KI BAITHAK RESTURENT[/TD]
[/TR]
[TR]
[TD]302[/TD]
[TD]CMH1201 (HASAN ALI)[/TD]
[TD]3802[/TD]
[TD]HYDERABADI BAR B.Q[/TD]
[/TR]
[TR]
[TD]303[/TD]
[TD]CMH1202 ( ALI)[/TD]
[TD]5194[/TD]
[TD]HYDERABAD SANDWICH HOUSE[/TD]
[/TR]
[TR]
[TD]303[/TD]
[TD]CMH1202 ( ALI)[/TD]
[TD]27540[/TD]
[TD]ROASTERS COFFEE HOUSE & GRILL[/TD]
[/TR]
[TR]
[TD]303[/TD]
[TD]CMH1202 ( ALI)[/TD]
[TD]116578[/TD]
[TD]NANDOS[/TD]
[/TR]
[TR]
[TD]304[/TD]
[TD]CMH1203 (HASAN )[/TD]
[TD]119132[/TD]
[TD]MOEVENPICK HOTEL[/TD]
[/TR]
[TR]
[TD]305[/TD]
[TD]CMH1203 (HASAN )[/TD]
[TD]119185[/TD]
[TD]SAFE FOOD CATERERS[/TD]
[/TR]
[TR]
[TD]305[/TD]
[TD]CMH1203 (HASAN)[/TD]
[TD]126625[/TD]
[TD]SALMAN ASSOCIATES (HIGHWAY GRILL REST)[/TD]
[/TR]
</tbody>[/TABLE]

I have to fill each of too many employees data in separate sheets. sheets are named after each employee code.

I need formula to fill the column B of 1st sheet with all the customer# looked after by employee# 302 in master data sheet.

I used Vlookup and matched 302 as criteria but vlookup repeats the 1st found match after the first match. ie



[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Emp[/TD]
[TD]302[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Serial[/TD]
[TD]Customer #[/TD]
[TD]Customer Name[/TD]
[TD]etc etc sale, qty, area[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]923[/TD]
[TD]A-1 BROST & BURGER FAST FOOD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]923[/TD]
[TD]A-1 BROST & BURGER FAST FOOD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]923[/TD]
[TD]A-1 BROST & BURGER FAST FOOD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


i tried hlookup but no use. i also tried basic index match but no use.
IF I copy entire master data of reqd sheet and then AUTOFILTER, the file gets so huge due to large data. tis is not the solution Plz help I just need all the Customer # (from C column) which have 302 in A column from master data sheet into the reqd sheet in B column or any other column.

ie
Reqd sheet
A B C D
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[/TR]
[TR]
[TD]Emp[/TD]
[TD]302[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Serial[/TD]
[TD]Customer #[/TD]
[TD]Customer Name[/TD]
[TD]etc etc sale, qty, area[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]923[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3032[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3754[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3802[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD].[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
rest (column D to ZZ) will be done afterwords with vlookup easily when the customer # are filled in B.