Forum Discussion

Carlos_Ney_Filho's avatar
Carlos_Ney_Filho
Copper Contributor
Jan 11, 2019
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...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 11, 2019

    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]") &"]")
ThirsT_2_Learn's avatar
ThirsT_2_Learn
Copper Contributor
May 19, 2019

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?

Carlos_Ney_Filho's avatar
Carlos_Ney_Filho
Copper Contributor
May 27, 2019

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.

 

Resources