Home

Excel 2016 how to autofill data entries based on a reference sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-664493%22%20slang%3D%22en-US%22%3EExcel%202016%20how%20to%20autofill%20data%20entries%20based%20on%20a%20reference%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664493%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20where%20I%20have%20several%20rows%20with%20companies%20information%2C%20one%20of%20them%20the%20correct%20name%20of%20the%20company.%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20a%20different%20user%20add%20new%20data%20related%20to%20currently%20listed%20companies%2C%20I%20need%20that%20if%20he%20or%20she%20starts%20to%20write%20name%20or%20acronyms%20it%20appear%20the%20info%20that%20has%20already%20been%20(Autofill)%20about%20this%20company.%3C%2FP%3E%3CP%3EHow%20may%20I%20do%20that%3F%3C%2FP%3E%3CP%3EAny%20suggestion%20will%20be%20welcome%2C%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3EBet%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-664493%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Betsa35
Occasional Visitor

I have a workbook where I have several rows with companies information, one of them the correct name of the company. 

When a different user add new data related to currently listed companies, I need that if he or she starts to write name or acronyms it appear the info that has already been (Autofill) about this company.

How may I do that?

Any suggestion will be welcome,

Kind regards,

Bet