Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Use Dropdown column to populate an alternate column in a sheet
I am trying to populate an address in a separate column with a dropdown column that has corresponding branch numbers in the same sheet. The user enters a branch number by dropdown and I would like it to populate the address column with the corresponding address for the branch. I am using a LOOKUP formula and it works with a single entry, but there are multiple choices and multiple results.
Is there a way to use the LOOKUP for multiple lookups?
Comments
-
Hi Shawn,
Not sure how you've got things set up, but I'll give you some ideas. You need to have a list of branches and address somewhere in the sheet. See the screen shoot. Then use that list for the lookup formula. With the Branch # as a dropdown. The formula for the address column:
=LOOKUP([Branch #]1, $[Branch # LU]$1:$[Address LU]$8, 2)
Good Luck
Shawn
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives