Hi Jaco,
After entering the v-lookup formulae in the required cell, you can use paset
- special format from the respective pivot field.

Signature
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
dilipandey@yahoo.com
dilipandey@gmail.com
New Delhi, India
> I'm using a vlookup function to import data from a pivot table but I'd like
> to import the format as well. From previous posts this is apparently not
[quoted text clipped - 4 lines]
> Any links to sites where one could learn a bit more about macros and coding
> would be helpful as well.