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

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,223,884
Messages
6,175,175
Members
452,615
Latest member
bogeys2birdies

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