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.
Lookup function to return unique rows
I have a data sheet (blue) where users fill out information about potential new hires for a job. I need to show the data with its attibutes accross for each position (grey). I'll later hide these columns and link to another sheet.
I'm trying to use the lookup function to pull the data into the position specific area, but getting duplicates using the formula below.
=LOOKUP("Manager A", $Position$2:$Name$8, 2, false)
The desired result is to see Adam, Bobby, Eric only. What can I do to achieve this?
Thank you.
Comments
-
The link to thte image is broken. Can you repost?
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives