+ Reply to Thread
Results 1 to 1 of 1

Data validation with multiple lists

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2013

    Data validation with multiple lists

    haven't been able to find a solution to my question after browsing the forum messages so i'm hoping i am able to describe the end result i hope to achieve.

    currently i'm working with two worksheets, the first worksheet is essentially the data entry screen and the second sheet is where all the predefined choices and auto fillin information is kept. the data that i deal with falls into several categories of which there are many items in each category. due to the sheer number of items i thought it best to narrow down the scrolling through an "all items list" by having a category list. the user chooses a category from the first list and as assumed, the second list (items) is dependent upon the category chosen in the first list (categories). the remainder of the hard coded data that will automatically fill the remaining columns i am using vlookup. being able to select any category and have it's related items show up works well but only the items in the first column will display the hard coded data that follows by using the vlookup function. i have attached an example of the worksheet.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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