 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006validation from two columns
does anyone know how to use validation to look at two columns at the same time ?  SignatureCHRISTOPHER GILBERT SHAMROCK INC RED LION BUSINESS CENTER 143 RED LION ROAD VINCENTOWN, NJ 08088 P.O. BOX 2537 PHONE: 609 859 2424 CHRISGILBERT@SHAMROCK-INC.COM HTTP://WWW.SHAMROCK-INC.COM What would the validation test? -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) > does anyone know how to use validation to look at two columns at the same > time ? [quoted text clipped - 8 lines] > CHRISGILBERT@SHAMROCK-INC.COM > HTTP://WWW.SHAMROCK-INC.COM 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 !! SignatureCHRISTOPHER GILBERT SHAMROCK INC RED LION BUSINESS CENTER 143 RED LION ROAD VINCENTOWN, NJ 08088 P.O. BOX 2537 PHONE: 609 859 2424 CHRISGILBERT@SHAMROCK-INC.COM HTTP://WWW.SHAMROCK-INC.COM > What would the validation test? > [quoted text clipped - 18 lines] > > CHRISGILBERT@SHAMROCK-INC.COM > > HTTP://WWW.SHAMROCK-INC.COM Try to adapt this function: =IF(and(L42>L43,L43>0),TRUE,FALSE) > does anyone know how to use validation to look at two columns at the same > time ? 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) > Try to adapt this function: > [quoted text clipped - 12 lines] > > CHRISGILBERT@SHAMROCK-INC.COM > > HTTP://WWW.SHAMROCK-INC.COM |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.