If cell entry does not match options = error
 

Cells A1 to A5 each have a word. The entry needed in A6 must be one of the
words in A1 to A5 exactly. I am wondering if there is a way to prevent the
entry of anything but one of the 5 options otherwise you would get an error
or blank entry or some other way to handle this?
--
Thanks Everyone
Mike

If cell entry does not match options = error
 

As a user, I think Data|Validation (xl2003 menus) would work nicely.

Debra Dalgleish explains he
http://contextures.com/xlDataVal01.html

ZIPPOMA NEEDS HELP wrote:

Cells A1 to A5 each have a word. The entry needed in A6 must be one of the
words in A1 to A5 exactly. I am wondering if there is a way to prevent the
entry of anything but one of the 5 options otherwise you would get an error
or blank entry or some other way to handle this?
--
Thanks Everyone
Mike

--

Dave Peterson