So, I am creating a calculator. I have a drop down list in one cell and the next cell gives me a drop down list based on the previous cell. My question is, why do the lists not recognize the names if there is a space in it?
EX:
State
Massachusetts
New York
Massachusetts
Boston
Andover
New York
Rochester
Buffalo
If I chose New York it won't read the NY list, if I put an underscore where the space is it will work, but I can't always have an underscore....Help...please?!
EX:
State
Massachusetts
New York
Massachusetts
Boston
Andover
New York
Rochester
Buffalo
If I chose New York it won't read the NY list, if I put an underscore where the space is it will work, but I can't always have an underscore....Help...please?!