Automated decision tree

%3CLINGO-SUB%20id%3D%22lingo-sub-2734156%22%20slang%3D%22en-US%22%3EAutomated%20decision%20tree%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2734156%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20workbook%20that%20will%20point%20to%20specific%20cells%20(outcomes)%20based%20on%20initial%20selection%20criteria.%20For%20example%2C%20I%20have%20the%20option%20of%20using%20Tubing%20A%20or%20Tubing%20B%2C%20and%20will%20need%20this%20Length%20A%20or%20Length%20B%2C%20with%20either%20Course%20Threads%20or%20Fine%20Threads.%20If%20you%20select%20Tubing%20A%2C%20with%20Length%20B%2C%20Fine%20Threads%2C%20it%20will%20point%20you%20to%20part%20number%20X%2C%20but%20if%20you%20choose%20Tubing%20A%2C%20Length%20B%2C%20but%20Course%20Threads%2C%20you%20get%20part%20number%20Y.%20The%20real%20life%20application%20has%20many%2C%20many%20more%20variables.%20I%20just%20need%20to%20be%20pointed%20in%20the%20right%20direction.%20What%20is%20this%20called%20and%20what%20types%20of%20Excel%20tools%20will%20I%20need%20to%20learn%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2734156%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2736782%22%20slang%3D%22en-US%22%3ERe%3A%20Automated%20decision%20tree%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2736782%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1150339%22%20target%3D%22_blank%22%3E%40Jmanson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMuch%20depends%20on%20how%20the%20raw%20database%20is%20laid%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20what%20you%20have%20described%2C%20I'd%20be%20inclined%20to%20start%20with%20some%20of%20the%20new%20Dynamic%20Array%20functions%2C%20notably%20%3CSTRONG%3EFILTER%3C%2FSTRONG%3E.%20Here's%20a%20YouTube%20video%20that%20Microsoft%20delivered%20to%20explain%20these.%20Note%2C%20they%20do%20require%20the%20most%20current%20version%20of%20Excel%2C%20but%20they're%20powerful%20enough%20that%20it%20would%20be%20worth%20your%20while%20to%20upgrade%20if%20you've%20not%20already%20done%20so.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20LOT%20will%20depend%20on%20how%20you%20have%20your%20data%20organized%20to%20begin%20with.%20If%20you%20want%20further%20help%2C%20it%20would%20help%20us%20help%20you%20if%20you%20could%20post%20a%20copy%20of%20the%20spreadsheet%20as%20you%20currently%20have%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

I am trying to create a workbook that will point to specific cells (outcomes) based on initial selection criteria. For example, I have the option of using Tubing A or Tubing B, and will need this Length A or Length B, with either Course Threads or Fine Threads. If you select Tubing A, with Length B, Fine Threads, it will point you to part number X, but if you choose Tubing A, Length B, but Course Threads, you get part number Y. The real life application has many, many more variables. I just need to be pointed in the right direction. What is this called and what types of Excel tools will I need to learn?

1 Reply

@Jmanson 

 

Much depends on how the raw database is laid out.

 

From what you have described, I'd be inclined to start with some of the new Dynamic Array functions, notably FILTER. Here's a YouTube video that Microsoft delivered to explain these. Note, they do require the most current version of Excel, but they're powerful enough that it would be worth your while to upgrade if you've not already done so. https://www.youtube.com/watch?v=9I9DtFOVPIg

 

A LOT will depend on how you have your data organized to begin with. If you want further help, it would help us help you if you could post a copy of the spreadsheet as you currently have it.

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...