Hi folks --

Similar question with the exact same title (multiple conditions), so I decided just to reply here rather than create a duplicate post --

I'm trying to get this custom validation to work:

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

It looks at the value entered in G10 and sees if it EITHER matches a list at G93-G98, OR is a six digit number.

The first part of the validation works fine.

The second part of the validation works only if it's entered by itself:

=AND(LEN(G10)=6,ISNUMBER(G10)+0)

The two validations won't work together with the OR operator.

This is driving me nuts! Any help appreciated!

Scott