SOLVED

INDEX MATCH DATA VALIDATION and Growing Table

Copper Contributor

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

 

 

 

4 Replies
best response confirmed by Carlos_Ney_Filho (Copper Contributor)
Solution

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! :)

@Carlos_Ney_Filho 

 

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?

@ThirsT_2_Learn 

 

Hi, more or less.

 

I had to make a workaround and use it in a simple way.


But the solution above was my guide.

 

1 best response

Accepted Solutions
best response confirmed by Carlos_Ney_Filho (Copper Contributor)
Solution

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]") &"]")

View solution in original post