Data Validation from a list - Always case specific?

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Hi

I have created a data validation list. If user types value instead of
selecteing from drop down does user always have to enter case specific.

Eg list is "Y" and "N". user cannot type "n"
 
Try a custom formula of

=EXACT(D1,INDEX($E$1:$E$2,MATCH(D1,$E$1:$E$2,0)))

where D1 is the DV cell and E1:E2 is your list.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
If you create the list by typing the values in the Data Validation
dialog box, the entries will be case specific.

If you refer to a list on a worksheet, the entries will not be case
specific. There are instructions here for referring to a list on a
worksheet:

http://www.contextures.com/xlDataVal01.html
 
Back
Top