Forum Discussion
Solved
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 conta...
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]") &"]")
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?
Hi, more or less.
I had to make a workaround and use it in a simple way.
But the solution above was my guide.
