Is it possible to do the following.

I have two separate spreadsheets that contain data in. Each record
within the spreadsheet has a unique identifier (Info Record).

Want to be able to merge the data from the two spreadsheets (Sheet 1 +
Sheet 2) into one (Sheet 3) based on the Info Record key. So where
the same Info Record numbers appear in each spreadsheet the data is
all brought together into a third spreadsheet.

Appreciate your help on this.

Kind Regards, Al Mackay. ( )


** SHEET 1 **
Info record Material Vendor Valid to
5300000000 0000443XSH 1004 00.00.0000
5300000001 0000444XSH 1004 00.00.0000
5300000002 67065257SH 1004 00.00.0000
5300000003 67105745SH 1004 00.00.0000
5300000004 0000442XSH 1004 00.00.0000
5300000005 0001002XSH 1004 00.00.0000
5300000006 0000755SH 1004 00.00.0000
5300000007 0001003XSH 1004 00.00.0000
5300000008 0001000XSH 1004 00.00.0000
5300000009 0001001XSH 1004 00.00.0000
5300000010 50654952BO 1004 00.00.0000


** SHEET 2 **
Info Record Plant Currency
5300000000 GB01 GBP
5300000001 GB01 GBP
5300000002 GB01 GBP
5300000003 GB01 GBP
5300000004 GB01 GBP
5300000005 GB01 GBP
5300000006 GB01 GBP
5300000007 GB01 GBP
5300000008 GB01 GBP
5300000009 GB01 GBP
5300000010 GB01 GBP
5300000011 GB01 GBP
5300000012 GB01 GBP
5300000013 GB01 GBP
5300000014 GB01 GBP



** FINAL LOOK - SHEET 3 **
Info record Material Vendor Valid to Plant Currency
5300000000 0000443XSH 1004 00.00.0000 GB01 GBP
5300000001 0000444XSH 1004 00.00.0000 GB01 GBP
5300000002 67065257SH 1004 00.00.0000 GB01 GBP
5300000003 67105745SH 1004 00.00.0000 GB01 GBP
5300000004 0000442XSH 1004 00.00.0000 GB01 GBP
5300000005 0001002XSH 1004 00.00.0000 GB01 GBP
5300000006 0000755SH 1004 00.00.0000 GB01 GBP
5300000007 0001003XSH 1004 00.00.0000 GB01 GBP
5300000008 0001000XSH 1004 00.00.0000 GB01 GBP
5300000009 0001001XSH 1004 00.00.0000 GB01 GBP
5300000010 50654952BO 1004 00.00.0000 GB01 GBP