vlookup different formats

[Frodoe]

Morning all

Column C in sheet 1 has differing formats which are needed.
Some barcodes have spaces in front of them which is needed.

How do I vlookup this column in the "working sheet tab" but keep everything exactly as is (spacing before select barcodes .etc)

Any help would be appreciated.

Regards
James