Is it possible to know which file it came from?

zacari01

New Member
Joined
Jun 19, 2020
Messages
8
Office Version
  1. 2016
Platform
  1. Windows
Hi. Can I get all the specific information I need in one master file? Here's a vague explanation of what I want to do.

File 1
NameFruitCountryPhoneColor
James RickAppleKorea555 555 5555Red
Terry WilliamsGrapesMalaysia444 444 4444Blue
Steph CurryMelonPhilippines333 333 3333Yellow

File 2
Name
FruitCountryPhoneColor
Lebron JamesBananaUSA111 111 1111Brown
Steph CurryMelonPhilippines333 333 3333Yellow
Rick WallsStrawberryRussia222 222 2222Orange


Now what I want in the Master file is this:
Based on the information given Name, Fruit, Country, Phone, and Color, I want to know which file they came from.
NameFruitCountryPhoneColor From
James RickAppleKorea555 555 5555RedFile 1
Terry WilliamsGrapesMalaysia444 444 4444BlueFile 1
Lebron JamesBananaUSA111 111 1111BrownFile 2
Steph CurryMelonPhilippines333 333 3333YellowFile 1, File 2
Rick WallsStrawberryRussia222 222 2222OrangeFile 2
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top