Comparing lists

[Guest]

I have two lists I want to "merge". They both have Order Number as a column.
I want to combine them into one list, and each list is over 3000 rows long.
How do I do this? Also - the order numbers aren't matching unless I retype
them in one of the lists (without changing any formatting). What's with that?

John

 

[Bernie Deitrick]

John,

Sometimes, numbers get entered as text, which will result in no matches. You need to enter a 1 into
a blank cell, copy that cell, select your 'number' cells, and do a pastespecial multiply to convert
the text to numbers. Do that to both lists.

Then to combine: it depends on what you mean by 'combine' - is the data the same type, or something
different. You might be able to use VLOOKUP formulas to match up the tables....

HTH,
Bernie
MS Excel MVP