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

Thomas Ferguson
edited 12/09/19 in Archived 2016 Posts


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.


This discussion has been closed.