Combine 2+ list to compare data within each

[DaveAtlanta]

Good Afternoon

I have multiple list of data with many of the items duplicated within each list, but the data relating differ. What I'm trying to do is combine the list so I can print different datacolumns from each for easy comparison. This situation reminds me of a matching test with items in both columns that need to be matched together.

How can I align the items into one sheet, but maintaining the integrity of data within each list?

I appreciate any suggestions and help
Dave

 

[Oorang]

Are your two lists of the same length? And are there any items missing on either list from the other?

 

[Oorang]

Are your two lists of the same length? And are there any items missing on either list from the other? If yes to both then just do data, sort and sort both lists the same way by primary key first and everything should match.
Otherwise you might consider vlookup. How many records do you have?

 

[DaveAtlanta]

yes my all my list vary in length. Most average 600 items each.

 

[Oorang]

For a list that short I would just use vlookup.

 

[DaveAtlanta]

VLOOKUP
Okay, I'll try it and see how well it works

Thanks
Dave

 

[DaveAtlanta]

I think this will work okay, but after removing duplicate codes I have just over a 1000 items to compare within 4 different list.

Is VLookUp still the better solution?

Also, I need help hiding all the '#N/A' that appear for unmatched items. Normally I can use an IF() to have it be "" (blank) instead of '#N/A' but I am having trouble incorporating that with this function.

Any ideas?

Again thank you for you help
Dave

 

[Oorang]

Hiding the #na's can be accomplished by nesting your vlookup in an IF using ISERROR:

=IF(ISERROR(VLOOKUP(A2,Sheet2!A:C,1,0)),"",VLOOKUP(A2,Sheet2!A:C,1,0))

To explain a little, this says if your vlookup generates an error show nothing (or "") otherwise show the vlookup.

Trivia:
You can use 0 instead of false for the final term of the vlookup.