Merge 2 excel files /info

Hi
I'm a complete noob with excel

I have 2 files with 1 column thats common
How do i merge the info together please

1 file has a (common) job number and a description (seperate column)

2nd file has the (common) job number and a location (seperate column)

I wish to end up with 3 column of info

Thanks ... Grant

This formula is entered into Cell C2 of sheet 1, then copied (drag) down the column.

Please Login or Register  to view this content.

See attached file

Open all of the Excel workbooks in the same instance of Excel.
You might have to click the internal "restore" button to see the individual workbooks.
Select all sheets you want to move by Ctrl+Clicking on the worksheet tabs.
Right click on one of the selected tabs, and choose Move or Copy...
In the dialog that pops up, select the destination workbook (your "Master" workbook) and then choose where to insert them.
The (move to end) option is likely what you want, but you can always reorder them later.
Choose Create a copy if you do not want the sheets to be removed from the first workbook
Click OK.
The selected worksheets will be moved or copied from the original workbook into your "Master" workbook. Just close the source wookbook and do it again with the next one, until you've collected all the worksheets you care about into one large wookbook. Make sure to save!