Hi Paul.

You're correct.

I need to be able to choose from the drop-down list under Learning Targets (Knowledge, Questioning, Research, Problem Solving, Leadership, Goals, or Production) and, based on that selection, the adjacent field needs to be populated with the corresponding list in the excel workbook (let's call those "I Can Statements".

That same feature needs to be repeated five times - allowing me to choose (for example) Knowledge two times with two different "I Can Statements" from the Knowledge list in excel, one Leadership target with one "I Can Statement" from the Leadership list, and maybe 2 Problem Solving targets with two "I Can Statements" from the Problem Solving list.

Does that sound doable?

Based on a previous post, it sound like the excel lists need to be configured differently. Am I correct in remembering that you said to someone else that all the content needs to be on a single line? I can get on that if needed. With what symbol do I separate each item?

Will that allow the drop-down list to be organized vertically?

So appreciating your help. Thank you.

Truly - I'm more than willing to pay someone to create this - if that is of interest. Funds are limited, but this will be a big time saver for me and others.