I'm currently trying to make column of lists (starting in D2 and going well into the D500's) that are dependent on a list in the corresponding C column. So for example:
A___B___C (1st list)_____D (list dependent on 1st list)
... __...____ Supplies____ Erasers
... __...____ Supplies____ Pencils
... __...____ Hardware___ Computers
... __...____ Hardware___ Printers
I'm using the: Indirect(C2) option, but its not working. I think it may be because each of my table names below (Material Type, Supplies, and Hardware) are set up as a dynamic table to keep automatically increasing the size of my list as new option is typed at the bottom of it (e.x., if 'Paper' were added to the Supplies table)
Sheet 2
column A_______column B____column C
MaterialType____Supplies____Hardware
_______________Erasers____Computers
_______________Pencils____Printers
________________Chalk____Monitors
Added later: Paper
My dynamic table ranges, using the MaterialType example, are: Offset(Products!$A$2,0,0,CountA(Products!$A:$A)-1,1)
Setting this up worked for the MaterialType in column C (sheet 1)- but keeps telling me I have an error when I try to integrate the INDIRECT(C2) option when developing the dependent list in column D.
Anyone have any advice?
PS - I had posted this before, but wanted to edit it. If anyone can tell me how to edit/delete previous posts, that would be great too. I had the 'edit' option for a little while, but when I went back to it, it was gone. Thanks.
A___B___C (1st list)_____D (list dependent on 1st list)
... __...____ Supplies____ Erasers
... __...____ Supplies____ Pencils
... __...____ Hardware___ Computers
... __...____ Hardware___ Printers
I'm using the: Indirect(C2) option, but its not working. I think it may be because each of my table names below (Material Type, Supplies, and Hardware) are set up as a dynamic table to keep automatically increasing the size of my list as new option is typed at the bottom of it (e.x., if 'Paper' were added to the Supplies table)
Sheet 2
column A_______column B____column C
MaterialType____Supplies____Hardware
_______________Erasers____Computers
_______________Pencils____Printers
________________Chalk____Monitors
Added later: Paper
My dynamic table ranges, using the MaterialType example, are: Offset(Products!$A$2,0,0,CountA(Products!$A:$A)-1,1)
Setting this up worked for the MaterialType in column C (sheet 1)- but keeps telling me I have an error when I try to integrate the INDIRECT(C2) option when developing the dependent list in column D.
Anyone have any advice?
PS - I had posted this before, but wanted to edit it. If anyone can tell me how to edit/delete previous posts, that would be great too. I had the 'edit' option for a little while, but when I went back to it, it was gone. Thanks.
