How can I compare two lists of numbers to see if they are the same?

[VILLABILLA]

Hi,

I have two long lists of data, so two columns. The lists should be th
same, what is the easiest way to compare these lists and trace an
differences?

Thanks a lot in advance

 

[anurag.d]

Hi,
Try vlookup on the lists.
If the values r different in one of the lists it will thrwo up th #N
error otherwise it will return the value from the othe column

 

[VILLABILLA]

Yeah, never thought of that, thanks a lot

 

[mzehr]

Hi,
Another option is to use the match function. It will also
return an error message if the value is not found, and
will also return the line value if the match is found.

See also Chip Pearson's website:
http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicate
s

HTH