Home

INDEX, MATCH, THEN DATA VALIDATION LIST Created in Table?

%3CLINGO-SUB%20id%3D%22lingo-sub-570177%22%20slang%3D%22en-US%22%3EINDEX%2C%20MATCH%2C%20THEN%20DATA%20VALIDATION%20LIST%20Created%20in%20Table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-570177%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20objective%20is%20this%3A%20I%20am%20working%20with%20a%20table%2C%20and%20pivot%20tables%2C%20to%20track%20exceptions%20on%20loan%20document%20preparation.%26nbsp%3B%20So%2C%20I%20have%20a%20list%20of%20general%20categories%20of%20exceptions%2C%20and%20deeper%20into%20those%20categories%20some%20specific%20notes.%26nbsp%3B%20However%2C%20I%20don't%20want%20the%20%22notes%22%20too%20specific%20to%20each%20loan.%20I%20want%20them%20to%20be%20controlled%20to%20general%2C%20memorized%20statements.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20an%20example%3A%20For%20the%20Exception%20Type%20%22Vin%22%20-%20there%20are%20three%20possible%20Exception%20Notes.%26nbsp%3B%20When%20the%20user%20enters%20%22Vin%22%20into%20the%20table%2C%20I%20would%20like%20for%20the%20next%20field%20to%20provide%20a%20data%20validation%20drop-down%20list%20of%20the%20three%20available%20options%20-%20plucked%20from%20a%20nearby%20table.%3C%2FP%3E%3CP%3EAfter%20reviewing%20several%20community%20conversations%2C%20specifically%2C%20%22michon%20rieben%22.%26nbsp%3B%20I%20was%20thinking%20INDEX%2C%20MATCH%2C%20but%20after%20that%2C%20there%20are%20three%20choices%2C%20just%20for%20this%20%22Vin%22%20Type.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20manner%2C%26nbsp%3Bthe%20results%20would%20be%26nbsp%3Bconsistent%20(and%20memorized)%20statements%20for%20the%20exception%20notes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20file%2C%20and%20included%20notes%20on%20the%20Validation%20worksheet.%3C%2FP%3E%3CP%3EI'm%20always%20asking%20the%20hard%20questions%E2%80%A6Can%20anyone%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-570177%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERequests%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-676358%22%20slang%3D%22en-US%22%3ERe%3A%20INDEX%2C%20MATCH%2C%20THEN%20DATA%20VALIDATION%20LIST%20Created%20in%20Table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-676358%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342559%22%20target%3D%22_blank%22%3E%40AngelaSmith0916%3C%2FA%3E%26nbsp%3BHello%20there.%20If%20I'm%20understanding%20you%20correctly%2C%20you%20want%20to%20be%20able%20to%20choose%20an%20item%20in%20the%20'Exc%20Type'%20column%20(on%20'MyTable'%20sheet%2C%20in%20'Table1')%2C%20and%20then%20have%20a%20drop%20down%20in%20'Exception%20Notes'%20dependent%20upon%20your%20selection.%20If%20this%20is%20correct%2C%20yes%2C%20it's%20possible.%20However%2C%20with%20your%20data%2C%20I'm%20not%20sure%20I%20follow%20how%20you're%20determining%20the%20dependent%20data.%20For%20example%2C%20if%20you%20choose%20%22Vin%22%2C%20where%20is%20the%20dependent%20data%20specifically%3F%20It%20looks%20like%20you%20currently%20have%20two%20disparate%20tables%20of%20data%20on%20'Validation'%20sheet.%3C%2FP%3E%3CP%3EHere%20are%20two%20examples%20of%20how%20to%20perform%20dependent%20validation%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fdependent-dropdown-lists%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fdependent-dropdown-lists%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fcontextures.com%2FxlDataVal02.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcontextures.com%2FxlDataVal02.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
AngelaSmith0916
Occasional Visitor

My objective is this: I am working with a table, and pivot tables, to track exceptions on loan document preparation.  So, I have a list of general categories of exceptions, and deeper into those categories some specific notes.  However, I don't want the "notes" too specific to each loan. I want them to be controlled to general, memorized statements.

 

Here's an example: For the Exception Type "Vin" - there are three possible Exception Notes.  When the user enters "Vin" into the table, I would like for the next field to provide a data validation drop-down list of the three available options - plucked from a nearby table.

After reviewing several community conversations, specifically, "michon rieben".  I was thinking INDEX, MATCH, but after that, there are three choices, just for this "Vin" Type. 

In this manner, the results would be consistent (and memorized) statements for the exception notes.

 

I have attached a file, and included notes on the Validation worksheet.

I'm always asking the hard questions…Can anyone help?

 

1 Reply

@AngelaSmith0916 Hello there. If I'm understanding you correctly, you want to be able to choose an item in the 'Exc Type' column (on 'MyTable' sheet, in 'Table1'), and then have a drop down in 'Exception Notes' dependent upon your selection. If this is correct, yes, it's possible. However, with your data, I'm not sure I follow how you're determining the dependent data. For example, if you choose "Vin", where is the dependent data specifically? It looks like you currently have two disparate tables of data on 'Validation' sheet.

Here are two examples of how to perform dependent validation:
https://exceljet.net/dependent-dropdown-lists
https://contextures.com/xlDataVal02.html

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies