Results 1 to 8 of 8

data validation

Threaded View

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    data validation

    Hello to all.
    I have 2 sheets:
    In one I have a database with a set of data that I have named "articles" with define > name
    in the second I enter this validation:

    if the number entered is not in "articles" or incorrectly reports the error.

    The formula as it should be done?
    I hope I was understandable.
    Thank you,
    max_max
    ------------------------------------------------------------------------------------------
    Ciao a tutti.
    Ho 2 fogli:
    In uno ho un data base con una serie di dati che ho nominato "articoli" con definire > nome
    nel secondo devo inserire questa convalida:

    se il numero inserito non è in "articoli" o è errato segnala l'errore.

    La formula come deve essere fatta?
    Spero di essere stato comprensibile.
    Grazie,
    max_max
    Last edited by max_max; 09-08-2013 at 03:12 AM. Reason: traslation wrong

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 07-03-2014, 02:37 AM
  2. Adding Date Data Validation to cells with List Data Validation
    By biggtyme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2013, 09:47 AM
  3. Using Defined Names with Data Validation Depend and Data Validation Multi Select
    By Vinnie Chan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2012, 05:36 PM
  4. validation rules not working when someone copy paste data on validation cell
    By jthakrar in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-17-2010, 03:36 AM
  5. [SOLVED] data validation-How to set data validation for user to key in 24H time format?
    By crapit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2006, 08:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1