Hello,

I am looking to create a dependent drop down with a list I have create to an already created table.
I am aware that I should probably be using the OFFSET function, but I do not know how to reference the previously created table. This table was created by someone else and I cannot access the original file.

So if I have a list of Children, A, B, and C and the if A is selected it will lead me to A's specific table and so on with B and C.

I know I have to reference the cell with the chosen option as well, so should I use the INDIRECT function? I am confused.

Please help!