Hi all,
Ive been searching the web for a while looking for a solution. I’m fairly new to this so could be missing a simple solution that I just don’t understand yet.
I am creating a form which needs to auto-populate both simple data and other lists from a large amount of data. No issues creating tables, lists and then having them create dependant lists. I’ve also been able to use vlookup to auto populate cells based in a single table. This is where my experience ends.
The problem:
I have created a dynamic dependant drop down list. I need the result from the drop down to auto populate other cells. I have placed the data that the dependant list uses in a table with the data it needs to auto populate with however I’m guessing this is the issue.
is there a solution? Or is there an easier way to have a drop down list auto populate other cells with another drop down list?
Very grateful for any help.
Ive been searching the web for a while looking for a solution. I’m fairly new to this so could be missing a simple solution that I just don’t understand yet.
I am creating a form which needs to auto-populate both simple data and other lists from a large amount of data. No issues creating tables, lists and then having them create dependant lists. I’ve also been able to use vlookup to auto populate cells based in a single table. This is where my experience ends.
The problem:
I have created a dynamic dependant drop down list. I need the result from the drop down to auto populate other cells. I have placed the data that the dependant list uses in a table with the data it needs to auto populate with however I’m guessing this is the issue.
is there a solution? Or is there an easier way to have a drop down list auto populate other cells with another drop down list?
Very grateful for any help.
