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

Copper Contributor

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?