All you need is a simple VLOOKUP.
The VLOOKUP command used here is:
This part ignores the last 4 characters (=001 etc).
Column F contains a copy of column D as the VLOOKUP command needs to work in that order.
I'll have a Latte. Thanks.