Assistance needed with the following formula...

Question

I'm trying to put the correct data (person) in the correct column for an Employee and their Management hierarchy, using the following formula:

=IF(VLOOKUP(Worker@row, {Active Workers Report - Mgmt Lvl}, 5, false) = "Team Lead", {Manager}, "")

Can someone help me correct the formula, so the Name of the Team Lead/Manager/etc. show in the correct column? If one doesn't exist, I'd like it to be blank.

I'm not sure what I'm doing wrong.

Paul Newcome · Answer

Can you describe in words how exactly you want the formula to work?

Mariann Carmen · Answer

The source sheet has a column for Employee Name, Manager and Mgmt Lvl2. I can't really share much more than that.

Ideally, I'd like my updated worksheet to look like this (without me forcing the data into the correct columns).

DKazatsky2 · Answer

Are you able to provide a screen shot of the source sheet? Block any sensitive data as needed.