So I have searched and found some similar questions, but the answers don't make sense to an Excel Beginner like me.
I have a sheet that requests the banker to select a specific Account type. When they select the account type, in the column to the right there will be available options (for that account type they selected) in a drop down where they can select one option they want for this act type. I have created names (In Name Manager) for all the account types along with the range of options that they have for each act type.
The answers that I have seen all reference things like offset or Index or match, and I trust that those will work but I guess I need an easier understanding of how I can make these work.
Again I hope this all makes sense. and someone will be able to help. I have used this forum many times and everyone has been so helpful.
I have a sheet that requests the banker to select a specific Account type. When they select the account type, in the column to the right there will be available options (for that account type they selected) in a drop down where they can select one option they want for this act type. I have created names (In Name Manager) for all the account types along with the range of options that they have for each act type.
The answers that I have seen all reference things like offset or Index or match, and I trust that those will work but I guess I need an easier understanding of how I can make these work.
Again I hope this all makes sense. and someone will be able to help. I have used this forum many times and everyone has been so helpful.
