i am new to google sheets - wondering how i can achieve the following: create a master shoping list of manual entries into cells of column A. Then, when i want to create the current week's shopping list i would type any keyword in the cells of column B and there would be an autocomplete dropdown of choices based on the entries in column A. thank you!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
google sheets - manual entries to cells in column A become the list source for autocomplete in column B
- Thread starter aonefun
- Start date
Excel Facts
Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Similar threads
- Replies
- 0
- Views
- 105
- Replies
- 0
- Views
- 45
- Question
- Replies
- 0
- Views
- 388
- Question
- Replies
- 0
- Views
- 307
- Question
- Replies
- 0
- Views
- 238
