Autofill

%3CLINGO-SUB%20id%3D%22lingo-sub-804357%22%20slang%3D%22en-US%22%3EAutofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804357%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20make%20something%2C%20that%20I%20don't%20know%20if%20it's%20possible...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20Page%2C%20with%20some%20columns%2C%201%20Name%2C%202%20Surname%2C%203%20phone%2C%20etc....%3C%2FP%3E%3CP%3EI%20would%20like%20to%20do%20a%20drop%20down%20list%20with%20the%201%20column%20(Name)%2C%20and%20I%20want%20that%20automatly%2C%20the%20columns%20of%20surname%20%26amp%3B%20Phone%20set%20behind%20the%20drop%20down%20list....%20Is%20that%20possible%3F%3C%2FP%3E%3CP%3EAnother%20way%2C%20it%20would%20be%2C%20to%20make%20drop%20down%20list%20of%20every%20column%2C%20but%20that%20the%20columns%20of%20surname%20or%20phone%2C%20will%20be%20linked%20to%20the%20name%20I%20choose%20on%20the%20first%20drop%20down%20list...%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20I%20explain%20myself%20good%20enoght....%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-804357%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804381%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804381%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392136%22%20target%3D%22_blank%22%3E%40Sergi360%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20create%20from%20down%20list%20with%20names%2C%20and%20for%20the%20selected%20name%20pull%20information%20from%20other%20columns%20using%20INDEX%2FMATCH%20or%20VLOOKUP%20on%20selected%20name.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804571%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804571%22%20slang%3D%22en-US%22%3E%3CP%3EPerfect!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804582%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804582%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392136%22%20target%3D%22_blank%22%3E%40Sergi360%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-836955%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-836955%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20again%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20another%20thing%20that%20I%20don't%20know%20how%20to%20do%20it.%3C%2FP%3E%3CP%3EI%20have%20done%20the%20list%2C%20and%20autofill%20with%20vlook%2C%20etc.%20But%20now%2C%20in%20the%20drop%20down%20list%2C%20I%20don't%20know%20how%20to%20do%20that%20while%20I'm%20writting%2C%20the%20dropdown%20list%20take%20that%20reference%20and%20shows%20only%20what%20matches...%20I%20mean%2C%20If%20I%20start%20writting%20%22Ser%22%2C%20the%20list%20have%20to%20show%20only%20the%20names%20that%20start%20with%20%22SER%22.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20open%20the%20book%20with%20the%20Excel%20Online%20at%20Ofice%20365%2C%20it%20works%2C%20but%20If%20I%20open%20it%20with%20the%20excel%20on%20Mac%20V16.28%2C%20it%20doesn't....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello everyone!

 

I'm trying to make something, that I don't know if it's possible...

 

I have a Page, with some columns, 1 Name, 2 Surname, 3 phone, etc....

I would like to do a drop down list with the 1 column (Name), and I want that automatly, the columns of surname & Phone set behind the drop down list.... Is that possible?

Another way, it would be, to make drop down list of every column, but that the columns of surname or phone, will be linked to the name I choose on the first drop down list...

I don't know if I explain myself good enoght....

Thanks!

 

4 Replies
Highlighted

@Sergi360 

You may create from down list with names, and for the selected name pull information from other columns using INDEX/MATCH or VLOOKUP on selected name.

Highlighted

Perfect!

 

Thank you!

Highlighted

@Sergi360 , you are welcome

Highlighted

Hi again,

 

I have another thing that I don't know how to do it.

I have done the list, and autofill with vlook, etc. But now, in the drop down list, I don't know how to do that while I'm writting, the dropdown list take that reference and shows only what matches... I mean, If I start writting "Ser", the list have to show only the names that start with "SER". 

If I open the book with the Excel Online at Ofice 365, it works, but If I open it with the excel on Mac V16.28, it doesn't....

 

Thank you all!