SQLDAXExcelPython
Leaderboard
LookupsMedium20 points

Manager name for each employee

In a new column of Employees, return each employee's manager name by looking up ManagerId (column D) in columns A and B. The head of sales has no manager and must show None. Write the formula for row 2; it is filled down for you, so lock the lookup range with $.

How your answer is tested

Your formula goes in a new column of the Employees sheet at row 2, and is filled down to the last row.

Show solutionLifetime

Runs in your browser with IronCalc, an open-source spreadsheet engine, so this isn't Microsoft Excel. The questions here were checked against real Excel, but a few functions such as AGGREGATE are not available.

Excel formulaselect text to run only that part
Loading editor…

Press Ctrl+Enter or Run to see the result here.