pulling all information from a list

[kns0029]

Hi there I am in need of pulling all items from a table that have the same item listed in another column to a seperate page.

mike	cheeseburger
katie	pickles
aaron	cheeseburger
tyler	french fries
ellie	pickles
taylor	cheeseburger
kyle	yams

<tbody>
</tbody>

<tbody></tbody>

So if the above was my table which is located on one tab, Tab A. I also have another tab, Tab B, with a drop down list with the items in column 2 from the above list. I want a new table to lookup the item chosen in the dropdown list from Tab B and repopulate all the people who have the item on a new table in tab B.

Help!!

 

[oldbrewer]

a simple macro that, say, looked for cheeseburger in second column of tab A
every time found copy the name next to it to tab b

would this be acceptable ?

 

[kns0029]

I was Hoping to Avoiding using macros/writing VBA just because we ran into issues the way we store and utilize these files.

 

[63falcondude]

How about this? Source: How To Return Multiple Match Values in Excel Using INDEX-MATCH or VLOOKUP

Excel 2010
	A	B
1	Food	Name
2	cheeseburger	mike
3	pickles	katie
4	cheeseburger	aaron
5	french fries	tyler
6	pickles	ellie
7	cheeseburger	taylor
8	yams	kyle
Tab A

Excel 2010
	A	B
1	Food	Cheeseburger
2	Names	mike
3		aaron
4		taylor
5
6
Tab B

Cell Formulas
Range	Formula
B2	{=IF(ISERROR(INDEX('Tab A'!$A$1:$B$8,SMALL(IF('Tab A'!$A$1:$A$8=$B$1,ROW('Tab A'!$A$1:$A$8)),ROW($A1:$B1)),2)),"",INDEX('Tab A'!$A$1:$B$8,SMALL(IF('Tab A'!$A$1:$A$8=$B$1,ROW('Tab A'!$A$1:$A$8)),ROW($A1:$B1)),2))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[kns0029]

This worked thank you

 

[63falcondude]

This worked thank you

Glad to help.

I'm new to MrExcel can you give ups or ratings on this for good help/ideas?

I cannot message you back for some reason. If you find a post helpful, you can click the "Like" button.