Forum Discussion
Structured Tables, Names and dynamic list
Hi everyone, New to Excel I try to achieve the following: Table_c Depending on the name selected ([Name]), I'd like to list possible actions ([Actions]) from table_b only for the type Grain (t...
Badoumba Does the attached workbook do what you are trying to achieve? Data Validation does not accept structured table references, so you have to define a name for each column that you want to reference. For example, I defined names for lstNames and lstTypes to be used in the INDEX / MATCH lookup, as well as Grain and Fruit to be returned by the INDIRECT function as follows:
=INDIRECT(INDEX(lstTypes; MATCH($D3; lstNames; 0)))
I'm not exactly sure if this is what you were going for. Check it out and see...
Hi djclements
Yes, perfectly! A big thank you for the tip!.
Just for the sake of understanding, can $D3 be replaced by a name also? I tried with lstName_c (=table_c[Name]) but it is not working.
Yes, perfectly! A big thank you for the tip!.
Just for the sake of understanding, can $D3 be replaced by a name also? I tried with lstName_c (=table_c[Name]) but it is not working.