Latest Lists

In Excel, how do I get a list of items based off of what another cell equals?

a little vague yes, let me try to explain. I have a table with headers and data underneath each header. On another sheet I have a drop down list made from all the headers in the table. What I want is on another sheet, a list created of all the data under each header that was chosen from the drop down list. Hope that explains it. thanks.

Public Comments

1. Let's Assume your data is in Sheet 1 Columns A, B, C with Headers In Sheet2. 1. Select Cell A1, 2. Click on Data Tab 3. Click on "Data Validation" -> "Data Validation" 4. In Allow: select "list" 5. In Source select your Headers in Sheet1. In my example (=Sheet1!$A$1:$C$1) This will create the dropdown list. 1. In the Any free cell (In this example B1) enter this formula. : =MATCH(A1,Sheet1!A1:C1,)-1 2. In Cell (A2) enter this formula: =OFFSET(Sheet1!$A$1,ROW()-1,$B$1) (Replace $B$1 with your cell’s address) 3. Copy this formula down as far as you need. This setup should do what you need.