How to extract multiple matches?

[thisisbaris]

Hi folks,

I am trying to extract multiple matches from one sheet into another sheet.
Using =VLOOKUP won't work as it only brings the first instance.

I have done some research and I think the solution is something more complicated with =INDEX and =SMALL and =ROW or =COLUMN ... but my brain cannot handle all of this? Can you please help?

I have a snippet of the first 10 rows below:

As you can see, I'd like column B to show the Unique ID of all Manchester Zone cells (there is only 1) while column C shows the Edinburgh ones (there are 2).

http://tinypic.com/view.php?pic=2qc06dy&s=9#.XGWzjaDgqHs

 

[AhoyNC]

If you have Excel ver. 2010 or later try:

Excel Workbook
	B	C	D	E	F
1
2	Man Zone ID	Edi. Zone		Unique	Loc. Zone
3	3	4		1	London
4		5		2	London
5		6		3	Man
6				4	Edi
7				5	Edi
8				6	Edi
Sheet