The short answer is no... Formulas and functions return values. They can
neither read nor return formats.

The only exception that I can thing of in your case would be if the itme
being looked up is formatted via a conditional format. If so and the CF is
the same for all of the values being referenced then just replicating the CF
in the new cell will replicate the format.
--
HTH...

Jim Thomlinson


"Danni2004" wrote:

I have to VLOOKUP a field in a table but I also want the format of that field
in the table too.

Is there a way to achieve this?

Thanks in advance!
Danni