How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

Hi,I have two Microsoft Excel spreadsheets which I want

This answer was rated:


I have two Microsoft Excel spreadsheets which I want to merge into one spreadsheet. They have one column in common, let's call it ID.

I only want to merge them in those cases where there is a match in both document for the ID.

I have made some print screens to show what I mean. This is spreadsheet number 1 This is spreadsheet number 2 After merging them I want it to look like this. Note that the ID which was only represented in one of the spreadsheets isn't in the result.

Please note I'm using Swedish version of Microsoft Office. I don't expect you to tell me in Swedish but please explain in a way (maybe with screenshots) so it's easy to follow.

Kind Regards

Let me know when you're back online so I can send you the file with the formula
Customer: replied 3 years ago.



I'm online now, but I'm in central European timezone so maybe it's hard to find a time which we both are online. If you want to send a file then my e-mail address [email protected]

Customer: replied 3 years ago.

I see my e-mail address was taken away from my message. But if you want to give me a file then maybe you can use a service like for example.

I'm in California, so I'm usually online between 4pm to 7am your time


Customer: replied 3 years ago.

Hi John,


I'm online now if you have the time to show me.

Welcome back :)

One moment, I am looking for the file that I had prepared a few days ago...
Ok here you go

Attachment: 2013-01-06_215820_vlookup.xls

The formula is in the yellow cell. Try changing the ID in column A to see how it works

Hope this helps.

Thank you for remembering to rate and/or add bonus if you found it helpful
John D and 4 other Microsoft Office Specialists are ready to help you