excel auto correct

%3CLINGO-SUB%20id%3D%22lingo-sub-2823397%22%20slang%3D%22en-US%22%3Eexcel%20auto%20correct%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2823397%22%20slang%3D%22en-US%22%3E%3CP%3Eversion%20for%20Mac%2C16.47.1%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20names%20on%20one%20sheet.%20I%20would%20like%20to%20reference%20those%20names%20on%20another%20sheet%20of%20the%20same%20workbook%20by%20typing%20the%20first%202%20letters%20of%20the%20name.%20Auto%20correct%20will%20reference%20this%20but%20only%20if%20the%20info%20is%20in%20the%20same%20column.%20How%20can%20I%20reference%20from%20another%20sheet%2Fcolumn%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2823397%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2827333%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20auto%20correct%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2827333%22%20slang%3D%22en-US%22%3ELook%20into%20Data%20Validation%20as%20the%20method%2C%20with%20that%20full%20list%20as%20the%20approved%20list.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-data-validation-guide%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-data-validation-guide%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

version for Mac,16.47.1 

I have a list of names on one sheet. I would like to reference those names on another sheet of the same workbook by typing the first 2 letters of the name. Auto correct will reference this but only if the info is in the same column. How can I reference from another sheet/column?

1 Reply
Look into Data Validation as the method, with that full list as the approved list.
https://exceljet.net/excel-data-validation-guide