Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation from two columns
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation from two columns
What would the validation test?
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Christopher Gilbert" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation from two columns
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation from two columns
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 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" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation from two columns
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
data validation list from two columns | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |