Numbers Forumula to find a Name in an table and report what's in the top row.

Hi everyone.

I need help with a formula for numbers. Essentially I have a database full of employee names and I need to convert it into a vertical column.

What I would like numbers to do is in the yellow box have a formula that looks for the employees name in the adjacent field, find it in the main Data table and then report back the name in the 1st row (Manager's name).

I've tried using LOOKUP (specifically LOOKUP(A2,Data::B2:D4,Data::B$1:D$1) and it seems to report back incorrect names half the time. Not sure where I'm going wrong. Please help.