Lookup from one table to another (multiple instances)

[onthegreen03]

I have a table which has product names in column A (some products are listed multiple times) and event related information for that product in columns B and C. On a different tab I want to be able to use a dropdown and when a product is selected it will search that entire table and return all of the instances when the name in the dropdown matches the name in the table. Is this possible? I was thinking a VLOOKUP would work but not in cases where there are multiple entries for certain product names. Hope this makes sense. I can send screenshots if needed for further clarity.

 

[Fluff]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

 

[onthegreen03]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

I am using Excel for Office 365. I will update my profile ... thanks for the tip!

 

[Fluff]

Thanks for that.
How about

+Fluff v2.xlsm
	A	B	C
1	County	District	Ward
2	Cumbria	Eden	Ullswater
3	Shropshire	Shropshire	Cleobury Mortimer
4	West Yorkshire	Calderdale	Todmorden
5	County Durham	County Durham	Weardale
6	Northumberland	Northumberland	South Tynedale
7	South Yorkshire	Sheffield	Stocksbridge and Upper Don
8	West Yorkshire	Bradford	Royds
9	Lancashire	Rossendale	Irwell
10	West Yorkshire	Kirklees	Holme Valley North
11	Devon	Teignbridge	Moorland
12	County Durham	County Durham	Consett North
13	North Yorkshire	Richmondshire	Leyburn
14	North Yorkshire	Richmondshire	Hawes and High Abbotside
15	Staffordshire	Staffordshire Moorlands	Ipstones
16	County Durham	County Durham	Barnard Castle West
17	Lancashire	Blackburn with Darwen	East Rural
18	Gloucestershire	Stroud	Bisley
Sheet1

+Fluff v2.xlsm
	A	B	C
1
2		West Yorkshire
3
4		Calderdale	Todmorden
5		Bradford	Royds
6		Kirklees	Holme Valley North
7
8
Sheet2

Cell Formulas
Range	Formula
B4:C6	B4	=FILTER(Sheet1!B2:C18,Sheet1!A2:A18=B2)
Dynamic array formulas.

 

[onthegreen03]

That was brilliant! Thank you Fluff!!

 

[Fluff]

You're welcome & thanks for the feedback.