the spreadsheet I have works but it has blank spaces from the drop down list, I want it with dynamic range in the list, but want to get rid of the blank spaces when picking on the drop down.
For example, I added this formula:
in the "Base_Sink" name range
instead of this:
why it don't work? my purpose is to get rid of the blank spaces when picking from the drop down list and I read in tutorials to add a dynamic range, but don't know why it don't work.
Please see attachments.