Linking certain values from one list to another

%3CLINGO-SUB%20id%3D%22lingo-sub-2096081%22%20slang%3D%22en-US%22%3ELinking%20certain%20values%20from%20one%20list%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2096081%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20would%20like%20to%20create%20a%20formula%20in%20excel%20that%2C%20if%20the%20cell%20next%20to%20it%20has%20a%20certain%20value%2Fword%20that%20matches%20the%20column%20header%20from%20another%20list%2C%20it%20will%20automatically%20display%20all%20of%20the%20row%20headers%20that%20have%20yes%20values%20inside%20that%20column%20and%20put%20it%20in%20the%20other.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Such%20as%2C%20If%20the%20first%20list%20has%20types%20of%20cars%20along%20the%20top%20and%20optional%20features%20listed%20on%20the%20left%20side%20of%20the%20graph%20with%20yes%2Fno%20values%20listed%20for%20each%20type%20of%20car%20in%20regards%20to%20if%20it%20contains%20that%20feature.%20Then%20in%20another%20sheet%20I%20want%20to%20input%20the%20type%20of%20car%20into%20one%20cell%20and%20then%20the%20cells%20next%20to%20it%20(vertically)%20only%20list%20the%20features%20the%20car%20has.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Also%2C%20how%20would%20this%20work%20if%20I%20wanted%20to%20type%20in%20two%20types%20of%20cars%20and%20the%20features%20for%20both%20those%20cars%20appear%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20And%20if%20I%20put%20values%20in%20the%20first%20list%20instead%20of%20yes%2Fno%2C%20how%20could%20I%20make%20a%20formula%20that%20would%20take%20the%20values%2C%20multiply%20them%20if%20there's%20two%20different%20columns%20the%20data%20is%20pulling%20from%20(such%20as%20two%20types%20of%20cars)%2C%20and%20display%20the%20%22features%22%20that%20have%20a%20certain%20value.%20E.g.%20if%20the%20list%20has%20values%20ranging%20from%200.25%20to%202%2C%20how%20could%20I%20make%20the%20second%20list%20display%20the%20features%20that%20are%20%26gt%3B1%3F%20And%20if%20there%20are%20two%20column%20data%20sets%2C%20it%20would%20multiply%20the%20values%20together%20and%20list%20the%20only%20features%20%26gt%3B1%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2096081%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello, I would like to create a formula in excel that, if the cell next to it has a certain value/word that matches the column header from another list, it will automatically display all of the row headers that have yes values inside that column and put it in the other.

 

1. Such as, If the first list has types of cars along the top and optional features listed on the left side of the graph with yes/no values listed for each type of car in regards to if it contains that feature. Then in another sheet I want to input the type of car into one cell and then the cells next to it (vertically) only list the features the car has.

 

2. Also, how would this work if I wanted to type in two types of cars and the features for both those cars appear?

 

3. And if I put values in the first list instead of yes/no, how could I make a formula that would take the values, multiply them if there's two different columns the data is pulling from (such as two types of cars), and display the "features" that have a certain value. E.g. if the list has values ranging from 0.25 to 2, how could I make the second list display the features that are >1? And if there are two column data sets, it would multiply the values together and list the only features >1?

1 Reply

@bpurdy 

Without the sample file it's bit time consuming to build the model based on your description and generate solution formulas making some assumption (which could be wrong). That also very depends on your Excel version and how exactly you'd like to structure the date.

 

With small sample showing source data and manually added desired result it'll be more chances that someone answer.