Comparing lists

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

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


"John in MN" <John in [email protected]> wrote in message
news:[email protected]...
>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