Re: Looking for a function for choosing from a list then that lists selects a column and updates target

AJ_Stratix 

Your description is a bit confusing. I'm attaching a file that demonstrates how to create what I call a Cascading Data Validation (also known as "drop down").

If this is not in line with what you're looking for, please come back and, if possible,

1. post a copy of your actual file (or a good facsimile of it) on OneDrive or GoogleDrive, with a link pasted here that grants access
2. see if you can create a clearer description of the task