How to merge the data from two different spreadsheet

Hello, I'm Suzanne. Recently I need to merge two spreadsheet in Excel into
one Spreadsheet. The data in both spreadsheet is totally not the same and the
only link between both spreadsheet is the case ID. So, is there any ways that
I can merge two spreadsheet into one and accordingly?
Thank you

Suzanne, Good afternoon. I

Suzanne, Good afternoon.

I believe that´s possible using the VLOOKUP function.

But you need to explain it better or save your spreadsheet at a free site like www.sendspace.com and put the link here.

Without seeing your layout it´s very difficult to help you effectively.

I may help you. Please, give us more information about your necessity.

Greetings from Brazil
---------------------------------------------------
Belo Horizonte,Mg - Brazil
Marcílio Lobão