Expected result 1: Data validation in D6 with list of unique values from column A – this works
Expected result 2: Data validation in D17 with list of values from column B where column A = D6 – this does not work – only the first value ‘red’ is shown in D17 data validation drop down – how to change =XLOOKUP($D6,INDIRECT(“TableTest[A]”),INDIRECT(“TableTest[B]”)) for it to show both red and green?