Wolfmanfafa
New Member
- Joined
- Nov 22, 2017
- Messages
- 6
Scenario:
I have a table of data that consists of Song titles, Key, and Tempo on a worksheet titled SONG DATA.
On a worksheet titled Set List, I have column A to enter a song title and have it auto-populate the Title, Key, and Tempo in B, C, & D if B matches A using VLOOKUP. Then set the print area to only B:D since A is the same as B.
Question:
Is it possible to have excel give me live updated suggestions as I type in column A for matches from the table? Much like google does as you're typing in the search bar.
I have a table of data that consists of Song titles, Key, and Tempo on a worksheet titled SONG DATA.
On a worksheet titled Set List, I have column A to enter a song title and have it auto-populate the Title, Key, and Tempo in B, C, & D if B matches A using VLOOKUP. Then set the print area to only B:D since A is the same as B.
Question:
Is it possible to have excel give me live updated suggestions as I type in column A for matches from the table? Much like google does as you're typing in the search bar.
