Matching 2 lists

[00skins]

Hi

I searched through a number of threads for the answer to this but was unsuccessful...

What I need to do is match 2 lists, each currently on a different worksheet.

Both lists are different apart from one column which is a unique identifier and appears in both lists. The list lengths do not match (1 has 27,000 rows, the other 24,000).

For example, worksheet 1 looks like this: (the bracketed numbers is to show which data come in which column)

(1)Barcode (2)Series title (3)Code (4)Section (5)Location
(1)FABG76 (2)CMS (3)C*** (4)IM (5)In Stock
(1)FAB200 (2)CMS (3)C*** (4)IM (5)In Stock

And worksheet 2 looks like this:

(1)Barcode (2)SKP (3)Cust Box (4)Dept ID (5)Description
(1)FABG76 (2)800 (3)344785 (4)COMPLAINTS (5)COMPLAINTS
(1)FABUZT (2)900 (3)3889556 (4)COMPLAINTS (5)COMPLAINTS

As you can see from the above lists, the only match between the 2 is the barcode.

What I need to do is match the 2 lists and bring them together, ideally showing the detail in worksheet 1 in columns A to E and the detail in worksheet 2 in to columns F to J all in the same worksheet, but only where the barcode matches. Where there is no match, either columns A to E or columns F to J would remain blank.

Is this possible? I really appreciate any help you can give me.

Thanks
00skins

[dcl123456789]

There are probably several ways to do it but here is one.

Create a named range of entire 2nd sheet called DB.

Use the vlookup function

=VLOOKUP($A2,db,2,FALSE)

Embed the function in an iserror to hide the #N/A where there is no match

=IF(ISERROR(VLOOKUP($A2,db,2,FALSE)),"",VLOOKUP($A2,db,2,FALSE))


see attached example