Lookup function to return unique rows

Thomas Ferguson

 

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)