Lookup Populate Grouped Information Based On DropDown Selection

[rich_cirillo]

Hello

Can the following be done with Dropdown Lists.I want to make a dropdown list with 30 groups.I have 3 example groups in excel 2010 spreadsheet attached

I need the dropdown list in cell B6 - prefer not to use code if possible

From the dropdown list i can select say Smiths Wholesale in B6 and it then displays the Name,Phone,Fax and Email exactly like the spreadsheet....Can i have all the groups in Sheet 1 and the Dropdown list will be in Sheet 2

Thanks
Rich
Excel 2010

[Excel Fox]

Try this..

Make a list of your group names....

Use Index+Match to lookup for the selected group, and then populate the corresponding values below that

[rich_cirillo]

Thank you