Apr 09 2021 05:53 PM
I have a question i have got two coloum i have one with the old product code and one with the new product code I need it to sort the new product code with the old one so I known what product code on the old one is still working
so I can update my price list
the first column is the new product code an d the two column is old data I have attach the sheet so you can see what I mean
Apr 09 2021 08:59 PM
@pjakl Perhaps VLOOKUP does what you need. Added formula in columns C, F and I, checking if the old code exist in the list with new ones. #N/A means that it does NOT.
Apr 10 2021 02:30 AM
Apr 10 2021 03:17 AM
@pjakl Correct! In this example, product code IBTN3340 is not found in the list of new codes.