What would be the best way to add data from one excel to another based on an email column.
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
rmartori
8 - Asteroid
‎11-10-2020
12:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So I need to combing 5 excel files into one excel.
Afterwards I have a 6th excel with two columns column A is just emails and column B is the employees rank within the company(associate, manager, etc)
In the 5 excel files I am merging together email is in column F and Title where I want to put the matching rank, is in Column E
What would be the best way to do this?
Labels:
- Labels:
- Help
1 REPLY 1
17 - Castor
‎11-10-2020
12:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @rmartori,
I the 5 excel files have the same structure you can use union tool.
To add information using something similar to vlookup function you need to use join tool.
