Replace names in excel column with reference to another excel file

IF there is 1 excel file contain Employee ID with name …
I want to add employee ID and replace the Name in different file with reference to above file…
Any Solution…

1 Like

hi @Shubham_Akole
is your second excel file contain your employee id ?

NO,only blank column…
But it contain only short name…I want to replace with proper name…

1 Like

so how did you going to match , name to name ?
can you show us the screen shot of excel if you dont mind or dummy data

so… have you tried vlookup ?


It Just Like…
I want Add Employee Id And replace Name …
33 Jayesh Patil 03-02-2019 9.35
44 Ganesh Dever 02-03-2019 8
44 Ganesh Dever 03-03-2019 9
.
.
. Just Like That…
Other File Contain Like …
EmolyeeID NAme
33 Jayesh Patil
44 Ganesh Dever…

@Shubham_Akole You want to replace the Employee ID and Name from another File which has Employee ID and Name right?

yes…

@Shubham_Akole It is similar to the previous Solution i had given you :sweat_smile:, If you can give me the files , I think i can do it

1 Like

@Shubham_Akole Check this Workflow :
If it’s the Output You needed, I still think there can be a more unique mappping as Mapping Names are Not good as How I achieved it in this Workflow. Since There was Nothing else to be Mapped :sweat_smile:
GroupByAndSum.zip (17.9 KB)

Please Notify If this in’t what you expected

1 Like