Hello,

I'm trying to Vlookup the value below and got errors all the time. The only thing that I think of was separating the item number out of the long text. However, this data was pulled from Oracle and it will overwrite the data to long text again when I refresh the system. Please advise and help.

17001~CHKIT ULTRA BALL2-PKMED