Paint Codes

Have to match paint for a Vauxhall Corsa T plate 99 Couple questions. Wonder if anyone could help.

1 Vin Numbers Which one is the paint code

is it the Z 147 XXEH

or is it in part of the chassis number ?

2 Having googled a fair bit on this matter. The information gained seems to show-: Paint matching straight from the "off the shelf aerosols" is not always a success.

Getting paint made up into an aerosol from a paint specialist may be better.

Any comments or personal experiences on the above would be great

BTIA