Touch up paint problems

[gksspot]

So I bought a bottle of touch up paint for my 02 Protege and after giving them my VIN upon request they told me I needed #28. My car's paint code is 24E which is Shimmering Sand Metallic. The bottle I got is WAY too silvery, there is absolutely no beige in it.
I went back to the dealer and they opened their book and did a search for 24E and it came out with the item number of #28 (they use the last two numbers of a long number).

My questions now...

-anyone with a light colored car ever have to apply multiple coatings for it to "darken" the filled in area to match the original paint?

-anyone ever get a bottle of touch up that was mixed bad and the color didnt match?

The other possibility was that the paint bottle was just labeled wrong. Im thinking of ordering a bottle of 28 from a different dealer...

...I had touch up paint for my Miata and it was a perfect match just wondering if Im loosing it.

[evilmonkeyMSP]

if you knew your paint code why didnt you just ask for a bottle of that?

[gksspot]

They asked for the VIN, seemed like they didnt want to do it any other way. The paint code and product number are not the same thing.
When I came back the second time thats when I had him look it up in a big book by paint code, still got the same product number (#28)

[Nutari]

the bottle of midnight blue mica they gave me doesnt match.. it comes out more purple than anything else.

[evilmonkeyMSP]

my blue mica matches perfectly...I just shook it for 10 mins

[Nutari]

my blue mica matches perfectly...I just shook it for 10 mins
Ive gotten 3 bottles so far.. all of them never match. did the shake forever thing too..

[gksspot]

That makes me feel better, I might get around to taking pics to show you how off the touch up paint is. I think I will try ordering some more from another dealer today.