Preformat the cells with the HLOOKUP() formula as Wingding


"Denny" wrote:

I have a data table set up that has wingdings2 as the format (to show a box
with a check mark). Each check indicates that a certain activity associated
with the row in the table is in play(a service will be performed). If a
service will not be performed than a box without a check mark in wingdings is
in the table. When I do a Hlookup to bring each element to a summary report
the lookup function returns the value which then must be reformatted. How do
I make sure the Hlookup function brings accross not only the value but the
format as well??