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.

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

Hi,

Try this calculated column formula

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

Hope this helps.