Forum Discussion
INDEX MATCH DATA VALIDATION and Growing Table
I have a table that contains a list of information that I want to use to fill two columns in another table.
Table1 has headers that I'll use in the first data validation list;
Every header contains information that will be used on the second data validation list;
This second data validation list depends on the first one value to bring possible entries;
I've created specific names on Name Manager to make it easier;
Everything is working fine, except for the fact that the new rows I add to the table, will have a reference for the first row instead so;
No matter the value of the row, it will always use the 1st row as reference.
Can someone help me? :D
Hi Carlos,
I guess that's since your names were not updated when you modified first table. Instead of names I'd suggest to use references on tables
=INDIRECT("Subcategory[#Headers]") and =INDIRECT("Subcategory[" & INDIRECT("Transactions[@Category]") &"]")
4 Replies
Hi Carlos,
I guess that's since your names were not updated when you modified first table. Instead of names I'd suggest to use references on tables
=INDIRECT("Subcategory[#Headers]") and =INDIRECT("Subcategory[" & INDIRECT("Transactions[@Category]") &"]")- I'll be checking if it works!
Thank you! :)Hi, did it work for you? I am also facing similar problem and unfortunately i am not that proficient and expert in Excel as you.
Could you please share, how you handled the problem?
