You can find out if an item is in one list, but not another with a formula like:

=if(isnumber(match(a1,sheet2!a:a,0)),"Found it","not there")

And you can retrieve the tracking number (just the first one that matches the
sales order number) using =vlookup().

Take a look at Debra Dalgleish's site for instructions on how to do =vlookup().
http://www.contextures.com/xlFunctions02.html

And Chip Pearson has lots of techniques for working with duplicates (as in two
lists) at:
http://www.cpearson.com/excel/duplicat.htm

Toby wrote:

Can anyone provide a solution to this scenario???

I have two worksheets with shipping information. First has sales order
numbers for our warehouse to ship and second sheet comes back to us with
sales order numbers and their respective tracking number from the warehouse.

Problem: Sometimes sales orders don't ship and I need to quickly compare the
two spreadsheets to see which sales order numbers from the first sheet don't
appear in the second sheet and therefore didn't ship.

I've scoured the Internet and can't find anything that quite works. A
formula that would seach both columns of info and record all sales order
numbers onto a 3rd spreadsheet would work best.

Thanks,

Toby

"Igor Green" wrote:

You may check our CompareIt tool (http://www.grigsoft.com/) - it can
compare excel files.

Igor Green
http://www.grigsoft.com
Compare It! + Synchronize It! : Files and folders comparison never was
easier!


--

Dave Peterson