Have two lists/columns need to compare/match the two in order to isolate the non-matching

%3CLINGO-SUB%20id%3D%22lingo-sub-1488033%22%20slang%3D%22en-US%22%3EHave%20two%20lists%2Fcolumns%20need%20to%20compare%2Fmatch%20the%20two%20in%20order%20to%20isolate%20the%20non-matching%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1488033%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Fine%20Excel%20Savvy%20Folks%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20for%20your%20wisdom%20and%20guidance!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20%22list%22%20of%20inventory%20items%20approximately%2015%2C000%20rows%2C%20comprised%20of%20three%20columns%2C%20A%3ATitle%2C%20B%3ABarcode%2C%20C%3AItem%23%20%26amp%3B%20a%20list%20(Column%20D)%20of%20Item%20%23s%20that%20have%20already%20been%20converted%2C%20or%20accounted%20for%2C%20approx%206500%20rows.%26nbsp%3B%20What%20I%20need%20to%20do%20is%20have%20the%20item%20%23's%20in%20column%20D%20match%20up%20with%20the%20item%23s%20in%20Column%20C%2C%20in%20order%20to%20identify%20the%20items%20that%20still%20need%20to%20be%20addressed%20(these%20would%20be%20the%20items%20that%20would%20have%20no%20match%20to%20Column%20C%20in%20Column%20D).%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20any%20of%20you%20kind%20and%20intelligent%20individuals%20could%20give%20me%20a%20sliver%20or%20your%20knowledge%20I'd%20be%20super%20grateful%20to%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much%20for%20your%20consideration%20and%20anticipated%20support!%3C%2FP%3E%3CP%3EKindest%20Regards!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1488033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello Fine Excel Savvy Folks, 

 

Looking for your wisdom and guidance!  

I have a "list" of inventory items approximately 15,000 rows, comprised of three columns, A:Title, B:Barcode, C:Item# & a list (Column D) of Item #s that have already been converted, or accounted for, approx 6500 rows.  What I need to do is have the item #'s in column D match up with the item#s in Column C, in order to identify the items that still need to be addressed (these would be the items that would have no match to Column C in Column D).  

If any of you kind and intelligent individuals could give me a sliver or your knowledge I'd be super grateful to you!

 

Thanks so much for your consideration and anticipated support!

Kindest Regards!

1 Reply
How do you want to identify the unmatched items?