Forum Discussion
Excel Drop Down Question
Requesting assistance to set up an Excel drop down list with 2 entries/choices. Each choice returns a table 7 cells x 5 cells. Looking for best solution using I believe xlookup and named ranges. Pl...
If you're really clever it's do-able with XLOOKUP but probably not sensible. A simpler solution might involve FILTER or INDIRECT but it's difficult to go into more depth without a sample of the workbook.