I would like a table of data to automatically display values based on a selectio

Question

I would like a table of data to automatically display values based on a selection a user makes in an in-cell drop down list. So, if my table of data looks like this...

...and I have an in-cell drop down that lists "Please select,Shirt,Pants" and the user selects "Shirt", I would like my table of data to automatically lists those rows that have "Shirt" in column A.

I know I could make the above table of data an actual Table and then have the user select "Shirt" or "Pant" from the header row in column A, but I have reasoning why I do not want to do it this way. So hoping my above scenario is fairly easy to do.

Thank in advance!

ITEM (column A) STYLE (column B) COLOR (column C) Shirt Short sleeve Navy Shirt Long sleeve White Shirt Tank top Gray Pant Dress Black Pant Dress Brown

Explanation / Answer

Try this

1. Copy the heading in cell A1 and paste it in cell A8

2. In cell A9 type Shirt

3. Click on cell B2 and go to Data > Advanced

4. In the List range, select A1:C6

5. In the Criteria range, select A8:A9

6. Click on OK

If you change then entry in cell A9 to Pant, then repeated steps 3:6 above.

Hope this helps.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---