In the example, create a list of fruits, nuts, and vegetables in a worksheet.Ģ. Create named ranges for each list: category = E4:G4, vegetable = F5:F10, nut = G5:G9, and fruit = E5:E11. This section describes how to set up the dependent dropdown lists shown in the example.ġ. So, in this example, we're picking up the text values in column B, and using INDIRECT to convert them to cell references by matching existing named ranges, like this: =INDIRECT(B6)ī6 resolves to the text "nut" which resolves to the range G5:G9. INDIRECT maps text to a named range, which is then resolved to a valid reference. In the example on this page, we're combining the latter idea with named ranges to build dependent dropdown lists.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |