VBA for vlookup that returns source formatting

[climbingchillie]

Hi

I'm a complete newbie to VBA and struggling to find a google answer that fits my specific needs and lack of knowledge.

I have 2 workbooks; One called 'Master' that contains a unique code in column A and a long text description with bold, coloured text and colour shading (not conditional, specific to each individual cell) in column B

The second workbook, "Audit", has the unique references in column B and i'd like to run the formula/return the result in column D.

Based on the unique reference in column A of "Master" matching column B in Audit i'd like to return the values of column B in Master including all formatting to column D in Audit.

Any help is greatly appreciated!

Master Example

A	B
GLA 2015/11	Does the client drive goods vehicles over 3.5 tonnes in London? If so, are they fitted with: (i) a class V mirror on the passenger side (ii) a class VI mirror to the front of the vehicle and (iii) sideguard

<tbody>
</tbody>

Audit example

B	C	D
Reference	Title	Audit Questions
GLA 2015/11	The GLA Roads and GLA Side Roads (London Safer Lorry Scheme) (Restriction of Goods Vehicles) Traffic Order 2015 (GLA 2015/11) <tbody> </tbody>	FORMATTED RESULT HERE

<tbody>
</tbody>