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
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies