+ Reply to Thread
Results 1 to 2 of 2

Data Validation with Multiple Independent Variables

  1. #1
    Registered User
    Join Date
    09-04-2013
    Location
    New Brunswick, NJ
    MS-Off Ver
    Excel 2007
    Posts
    1

    Smile Data Validation with Multiple Independent Variables

    Hi everyone, could really use some help before my boss yells at me!!!

    I'm attempting to create a spreadsheet that can easily relay data to the user. I have 3 lists I need to compare:

    Location --> Process --> ID#

    With values such as....
    Location: Hong Kong, Brazil, Tenessee, Mission Hills
    Process: Common Base, By Batch, Post Addition
    ID#: 111111,222222,33333,444444,55555 etc. etc.

    The problem is each location has the same three processes, but each process completely different ID#'s.

    Example: I select 'Hong Kong' from a list. The following list then shows 'Common Base, By Batch, Post Addition'. I select 'Common Base' and a third list should show '1111,2222,3333 etc' and allow me to select an ID#.

    Hope someone can help, you will recieve all the internet karma you can handle.

  2. #2
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Data Validation with Multiple Independent Variables

    tdames,

    Welcome to the forum!
    Have a look here: http://www.contextures.com/xlDataVal02.html
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. graph with 1 dependent and 2 independent variables
    By beni12 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-05-2018, 09:41 PM
  2. Replies: 4
    Last Post: 12-29-2010, 01:02 PM
  3. Bar Chart with two independent variables
    By pnut4912 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-25-2009, 12:51 PM
  4. graph an equation with 2 independent variables
    By jcavigli in forum Excel General
    Replies: 0
    Last Post: 06-30-2009, 02:48 PM
  5. [SOLVED] how to look up values with two independent variables
    By charlesfung in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-17-2006, 10:35 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