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)

 

[Jessica]

Try to adapt this function:

=IF(and(L42>L43,L43>0),TRUE,FALSE)

 

[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]

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)