Forum Discussion
Solved
Auto populate a cell with a table (column) on another sheet.
I have an application where I want to auto populate a cell with a drop down from a (column) table when a certain value is chosen in a third cell. This is so the User can only make a selection from th...
You'd have to create names such as Medallion_Silver_Drawers and Medallion_Gold_Drawers for this to work.
The data validation of C28 could then have as source
=INDIRECT(SUBSTITUTE(C8, " ", "_")&"_Drawers")
Thank you so much! I wish I could buy you a steak dinner!