Data Validation from a list - Always case specific?
 

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"
--
Kevin

Data Validation from a list - Always case specific?
 

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)

"Kevin" wrote in message
...
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"
--
Kevin

Data Validation from a list - Always case specific?
 

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


Kevin wrote:
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"


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html