Find and Relpace from a table

%3CLINGO-SUB%20id%3D%22lingo-sub-2746689%22%20slang%3D%22en-US%22%3EFind%20and%20Relpace%20from%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2746689%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20of%20sports%20team%20names.%20When%20I%20start%20to%20type%20a%20team%20name%20in%20a%20different%20cell%20I%20want%20to%20auto%20search%20the%20table%20and%20complete%20the%20team%20name%20when%20I%20type%20the%20first%202%20or%203%20letters%20of%20the%20team%20name.%20Any%20help%20is%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2746689%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2746861%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20Relpace%20from%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2746861%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1154675%22%20target%3D%22_blank%22%3E%40rwrobboutlookcom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDepending%20of%20the%20complexity%20of%20your%20project%20you%20just%20need%20to%20use%20Validation%20Data.%3C%2FP%3E%3CP%3EWhere%20the%20user%20Selects%20the%20TEAM%20and%20them%20all%20the%20respective%20adjacent%20columns%20of%20data%20will%20be%20populate.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a table of sports team names. When I start to type a team name in a different cell I want to auto search the table and complete the team name when I type the first 2 or 3 letters of the team name. Any help is appreciated.

3 Replies

@rwrobboutlookcom 

 

Depending of the complexity of your project you just need to use Validation Data.

Where the user Selects the TEAM and them all the respective adjacent columns of data will be populate.

@Juliano-Petrukio 

 

Thanx Juliano. I am using Data Validation with pull down lists. Problem is the list can have 30 teams. It would be nice to type the first 2 or three letters to narrow the list down automatically. Have a good one.

@rwrobboutlookcom 

It works, but in Excel for web