validation from two columns

[Christopher Gilbert]

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
[email protected]
HTTP://WWW.SHAMROCK-INC.COM

[Bob Phillips]

What would the validation test?

--

HTH

Bob Phillips

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

"Christopher Gilbert" <[email protected]> wrote
in message news:[email protected]...
> 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
> [email protected]
> HTTP://WWW.SHAMROCK-INC.COM

[Jessica]

Try to adapt this function:

=IF(and(L42>L43,L43>0),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
> [email protected]
> HTTP://WWW.SHAMROCK-INC.COM

[Christopher Gilbert]

i just need to use the list function. i'm going to use it in conjunction with
vlookup but i need the validation to see twio columns and not one. thanks for
all the help !!
--
CHRISTOPHER GILBERT
SHAMROCK INC
RED LION BUSINESS CENTER
143 RED LION ROAD
VINCENTOWN, NJ 08088
P.O. BOX 2537
PHONE: 609 859 2424
[email protected]
HTTP://WWW.SHAMROCK-INC.COM


"Bob Phillips" wrote:

> What would the validation test?
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> "Christopher Gilbert" <[email protected]> wrote
> in message news:[email protected]...
> > 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
> > [email protected]
> > HTTP://WWW.SHAMROCK-INC.COM
>
>
>

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> Try to adapt this function:
>
> =IF(and(L42>L43,L43>0),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
> > [email protected]
> > HTTP://WWW.SHAMROCK-INC.COM