Ah, I see.

No you can't do that, the best you can do is concatenate them in another
column and referee to that.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Jessica" wrote in message
...
Try to adapt this function:

=IF(and(L42L43,L430),TRUE,FALSE)

"Christopher Gilbert" wrote:

does anyone know how to use validation to look at two columns at the
same
time ?
--
CHRISTOPHER GILBERT
SHAMROCK INC
RED LION BUSINESS CENTER
143 RED LION ROAD
VINCENTOWN, NJ 08088
P.O. BOX 2537
PHONE: 609 859 2424

HTTP://WWW.SHAMROCK-INC.COM