Sep 13 2021 11:26 AM
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.
Sep 13 2021 11:59 AM
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.
Sep 13 2021 01:34 PM
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.
Sep 13 2021 01:40 PM
It works, but in Excel for web