Find and Relpace from a table

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



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.



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.


It works, but in Excel for web