LIST function?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: LIST function?

  1. #1
    Board Regular
    Join Date
    Nov 2002
    Location
    Orlando, FL
    Posts
    111
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi,

    Great site. Wish I would've known about this site a long time ago. Working on an input file and rather then have users choose from a drop down menu of choices I was wondering if there's a way (function) that only accept an input if it exists in an accompanying list or table.

    For instance, users are asked to input a resort. If their answer does not exist in the list their answer would show up as an error.

    I get the feeling this would probably work in Access and not Excel, but any suggestions would be greatly appreciated.

    Thanks

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    14,181
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi - welcome to the board!

    Check out the data validation function, which you can use to constrain valid entries. Post back if it's not clear...

    paddy

  3. #3
    Board Regular
    Join Date
    Nov 2002
    Location
    Orlando, FL
    Posts
    111
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks pdaddy,
    You da man!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com