Hi,
In column A in the attached workbook I have list of Product Code.
I would like to create a formula in column B that will return the Alternative Code from column D.
The rule for this it that if the first two characters of the Product Code are "AB" or "AC", the formula should return the Alternative Code that ends with the same 6 digits.
In my example, "AB123456" starts with "AB" so an Alternative Code that ends with 123456 should be returned, "GG123456" in this case.
Can someone please suggest a formula to accomplish this?
Thanks!
Bookmarks