Merging information

Closed
Mixxer40 Posts 1 Registration date Thursday May 15, 2014 Status Member Last seen May 15, 2014 - May 15, 2014 at 01:21 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 19, 2014 at 10:34 AM
I am taking inventory by sku number and have downloaded info from scanners and now I have it in excel and my original database is excel and I want to match up the 2 by sku and then merge them so the information will be merged and I will be able to see if there is a variance in my inventory.

If I am not asking this correctly please let me know as I am fairly new to excel and I just took over an account that hinges on me figuring this out so any help will be GREATLY appreciated.
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 19, 2014 at 10:34 AM
Hi Mixxer40,

What I understand is that you have 2 files which you want to compare the "sku" number with.

It is unclear to me what you want when a match is found. You say you want to merge the information. Merge in Excel means to make multiple cells look like one.

Please explain in greater detail how your data looks now and how you foresee it.

Best regards,
Trowa
0