Can't type in cell with drop down list

I have a spreadsheet with several cells that have drop down list valadation, I can directly type into all but one, no matter what I put in the one cell it gives me an error. Also, there is a cell that uses that particular cells results in a formula, and it doesn't recognize data from that cell. I have made sure that everything is formatted the same, and cannot figure this one out. I wanted to insert the file but for some reason it won't let me attach it. When I click the attachment icon nothing happens. I need help!

OK, I did that, and now I can type in something without the error, but there are several other cells that reference that one, and none of the formula's will reference that cell. This is wacky.

Are you able to upload a sample from the workbook to show what's happening?

By switching off the error-checking, it's possible that your formulas no longer work if they depend on the value you've entered - after all, that's the point of data validation

Without seeing the formulas though, it's hard to say

I wanted to insert the worksheet but couldn't - the insert button did nothing unless I am not doing it correctly, I have never included the spreadsheet before.

For some reason the validation isn't working on my dropdown list, which like you said is what it does. That is why I cannot type directly into the cell and have it work like the others I have drop down lists in, but I can't figure out what is different in that one.

Try this to upload your workbook:

Click on the "Go Advanced" button, then scroll down to "Manage Attachments"

You can then choose your file and click on the Upload button.

Thank you!

Cell B5 on the CDP FINISHED SIZES tab is the problem child. I can type directly into B7, N2, B3, but not into B5.

I think I see the problem!

If I switch off the error checking on B5 I can type in "ALBANY" but this then results in #N/A error in other formula cells (E5, B8, N3, N8, N9, P8 and P9). This is because they are checking for a match to B5.

When I checked your list range for the validation (STDDOORSTYLES), the values in column A on CDP SPECS sheet have lots of blank spaces after the name so, although they look the same the VLOOKUP will not find them.

You could use TRIM(A8) (and copy down) in a new column on CDP SPECS then copy the values back to column A, or only use the list selection in B5 (switch the error checking back on).


Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the star on the left is appreciated.

Thank you SO MUCH, I have been trying to figure this out for a long time, and it finally works. So it was the extra spaces at the end of the words that it didn't like? All of the dropdown lists are that way, and all worked but that one. Oh well, as long as it works I am a happy camper. Thanks again!

Those hidden spaces can be a real pain!

Don't forget to mark your thread as solved