VLOOKUP returns only values, not formatting......you would need VBA for that.

BTW, how does one tell the difference between 200 colors?

Vaya con Dios,
Chuck, CABGx3



"Janet" wrote:

Hi Folks
One of my colleagues is using VLookup to identify data. Is it possible for
the Lookup to not only pickup the contents of the field, but also the
formatting?

I suggested he use Conditional Formatting, but he needs approx 200 colours
which aren't available in Conditional Formatting.

thanks for all your help.
--
Janet