I have 3 columns, the 3rd column reads off of a drop-down list from the 2nd which reads off of a drop-down on the 1st column via INDIRECT. Each of the 3 columns is a drop down list containing text and a few have commas.
I have one issue, some of my names in the lists have commas.
For example. If I put Shirt in column 1, column 2 will have a drop-down list, if the phrase "Tank, Cami" is selected in column 2 I want my list in column 3 to appear (as it does with the other items that don't have commas). Currently I get the 3rd column to work, except when column 2 contains a comma.
I get an error message from excel stating:
Does anyone know of a way to get NAME MANAGER to understand/read/recognize a comma? I tried using underscores, colon, semi colon, no luck. I need to stick with using INDIRECT because of the multiple drop down lists in the spreadsheet.
I have one issue, some of my names in the lists have commas.
For example. If I put Shirt in column 1, column 2 will have a drop-down list, if the phrase "Tank, Cami" is selected in column 2 I want my list in column 3 to appear (as it does with the other items that don't have commas). Currently I get the 3rd column to work, except when column 2 contains a comma.
I get an error message from excel stating:
The name that you entered is not valid.
Reasons for this include:
Reasons for this include:
[*=2]The name does begin with a letter or an underscore
[*=2]The name contains a space or other characters
[*=2]The name conflicts with……(the remainder is not relevant)
Does anyone know of a way to get NAME MANAGER to understand/read/recognize a comma? I tried using underscores, colon, semi colon, no luck. I need to stick with using INDIRECT because of the multiple drop down lists in the spreadsheet.
