Updating cells based selection drop down list data validation

Posted by / 01-Mar-2020 17:32

Updating cells based selection drop down list data validation

I just typed in the information then converted to a Table.

Category and Item Table " data-medium-file=" data-large-file=" class="alignnone size-full wp-image-8016" title="Category and Item Table" src=" alt="Category and Item Table" width="271" height="184" / is the name of the Table created in the step above.

As your Table expands, with more rows or columns, this dynamic drop-down list will work just fine.

Tables are available in Excel versions 2007, 2010, and 2011.

Name Manager for my List " data-medium-file=" List-340x195.png" data-large-file=" List.png" class="alignnone size-full wp-image-8046" title="Name Manager for my List" src=" List.png" alt="Name Manager for my List" width="612" height="351" srcset=" 612w, List-340x195340w" sizes="(max-width: 612px) 100vw, 612px" / Type Item in cell B1.

Select cell B2 and open the Data Validation dialog box.

We can create a second defined name that will give us a dynamic list with the exact count. =OFFSET(my Item List,0,0, COUNTA(my Item List),1) This formula uses the first defined name () but alters the height by counting the items.

I named this defined name my Item, as you can see below in the Name Manager screen shot.

updating cells based selection drop down list data validation-33updating cells based selection drop down list data validation-84updating cells based selection drop down list data validation-74

But I am not a excel semi-pro as you 😉 Do you have any hint to give me? For example, in your excel file, if I change A2 from fruits to vegetables, B2 still displays “Banannas”.