Hi Guys,

A bit late, but better late than never.

I finally managed to fix the problem by adding a second step to the process; having a VLookUP in the worksheet do the work.
Lucky coincidence; this extra step adds more flexibility to the worksheet as several other worksheets can read from it too.

Thank you guys for your help!