I saw that a dependent drop-down list can be made using xlookup, but they were using cell references. Is there a way to use xlookup data validation dependent drop-down list within a table referencing a different table?
I saw that a dependent drop-down list can be made using xlookup, but they were using cell references. Is there a way to use xlookup data validation dependent drop-down list within a table referencing a different table?
Try using INDIRECT. The attached workbook gives an example. The first selection is made in Cell B2. Cell B4 computes the reference. Cell B6 has the INDIRECT lookup.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Here's a link to a webpage and video from Mynda Treacy on doing dependent drop-downs and validation using O365.
https://www.myonlinetraininghub.com/dynamic-dependent-data-validation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks