Populate table based on drop down selection

**skylights89** · 03-23-2015, 07:04 AM

Hi,

I have data in one sheet "Data", on "sheet2" I would like to be able to choose from a drop down the Dept name and have a table below populate based on the criteria.

E.G

If Dept1 is selected then display all of dept1 products and so on

The data is not in any current table format

Would anyone be able to help with this, I hTestfile.xlsx Testfile.xlsxave attached workbook of example data

**NeedForExcel** · 03-23-2015, 07:14 AM

Here!

=IFERROR(INDEX(Data!B$3:B$18,SMALL(IF($B$3=Data!$D$3:$D$18,ROW(Data!$D$3:$D$18)-ROW(Data!$D$3)+1,""),ROWS($B$7:$B7))),"")

Commit using Ctrl+Shift+Enter

But you will have to see the file attached for some minor recommended changes.

Testfile.xlsx

Cheers!

**skylights89** · 03-23-2015, 07:17 AM

Amazing!! Thank you

Populate table based on drop down selection

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Populate table based on drop down selection

Re: Populate table based on drop down selection

Re: Populate table based on drop down selection

Thread Information

Users Browsing this Thread

Similar Threads

populate table based on drop down selection

[SOLVED] Populate a group of cells below Drop Down Menu based on Drop Down Selection

[SOLVED] Populate Table with data from other sheets based on drop down selection

Populate Table from other sheets based on drop down selection

Populate Table from other sheets based on drop down selection

Bookmarks

Bookmarks

Posting Permissions