Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to paste a managers email across columns

Hi all, I have a table that looks like this   Employee Name Employee Manager Employee Email Manager Email Employee 1 Manager 1 Employee 1 @work Manager 1 @ work Manager 2 Manager 1 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Try this calculated column formula

    =lookupvalue(Data[Employee email],Data[Employee manager],Data[Employee Name])

    Hope this helps.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

You can do that in either Power Query or DAX.  For larger lists likely DAX is faster.

 

Your sample data is not complete, it is missing the Employee entry for Manager 1. Please correct.