Thread: Data Validation - Custom question (multiple conditions)
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Data Validation - Custom question (multiple conditions)
Hi Scott,

Am Sun, 6 May 2012 22:04:31 +0000 schrieb FoulFoot:

=OR(MATCH(G10,$G$93:$G$98,0),AND(LEN(G10)=6,ISNUMB ER(G10)+0))

try:
=OR(ISNUMBER(G10)*(LEN(G10)=6),ISNUMBER(MATCH(G10, $G$93:$G$98,0)))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote