Hi, I am trying to create a Vlookup where I have a set of classification short codes (SSU, WG, RG, RO) but the customer breaks each of those classes into 8 digit codes for ST, OT, DT (SSU ST = 12345678, SSU OT = 12345777, SSU DT = 123458888).
The first tab has ST OT DT at the top, and the...