Assuming yuo have named your ranges correctly and you want the char(29) at the end, which you do not mention, we do not know what is happening to give a good answer. However your named range highlighted in red appears to be the opposite way round to your description

This worksheet list is called UNAS_SHIPPED. the formula i have made is the following one:
=VLOOKUP(TRIM((SUBSTITUTE(B2;CHAR(29);"")) );SHIPPED_UNAS;29;FALSE)

I guess you may have to tell us more information

Regards

Dav