I have 14 different cases stemming from one letter in a product code. I tried writing two nested if statements together, but it only seems to work for the first 7 conditions, and when it falls within the first 7 conditions there is a zero added to the end of the cell.
When ever the letter falls within the second set of conditions the formula does not work. I believe I will have to write a vba but I am not sure how to set up the code.
I have pasted the formula I used below
=IF((MID(A5,13,1))="A","N1 WM",IF((MID(A5,13,1))="B","N1 FS",IF((MID(A5,13,1))="C","N12 WM",IF((MID(A5,13,1))="D","N12 FS",IF((MID(A5,13,1))="E","N3R WM",IF((MID(A5,13,1))="F","N3R FS",IF((MID(A5,13,1))="G","N4 WM")))))))&IF((MID(A5,13,1))="H","N4 FS",IF((MID(A5,13,1))="I","N4X WM",IF((MID(A5,13,1))="J","N4X FS",IF((MID(A5,13,1))="K","N3R WM (304 OR 316 STAINLESS)",IF((MID(A5,13,1))="L","N3R FS (304 OR 316 STAINLESS)",IF((MID(A5,13,1))="O","OPEN STYLE, NO ENCL",IF((MID(A5,13,1))="X","SPECIAL")))))))*1
Bookmarks