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.
