Matching Numbers in Two Different Columns and removing the Non matching
Hello Everyone,
I could really use some help. Column A has a list of 5000 Sku's, Column B also has a list of Sku's (11,000) that match UPC's in Column C. Column A has the Sku's I want the UPC's for. I need to some how remove the Sku's I don't need in Column B & C. So At the end I'm left with the 5000 Sku's in Column B I need and the corresponding UPC's in C.
Example:
Any help would be greatly appreciated.
Please Login or Register to view this content.
LK
Hi and welcome to the forum,
Insert a column between A and B.
In B1, type this formula :and copy down.Please Login or Register to view this content.
You can now remove column C and D (but first make sure to copy-paste the values from column B)
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Thank you that worked perfectly!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks