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
Sergi360
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

@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.

Perfect!

 

Thank you!

@Sergi360 , you are welcome

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!

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies