It should work, assuming "Type" is the name of the range
that contains the table of data, c14 exists in the top row
of the "Type" range and the desired value is in the 2nd
row of the range.

If the table is not in order, you should add "False" to
the lookup function:

HLOOKUP(C14,Type,2,False)

Hope this helps.

-Tim U

-----Original Message-----
I am having problem with a HLOOKUP.

I have few columns assinged for certain items. Those
items are
catergorized into 3 catergories. Each catergory is merged
and
centrered under the items. On the next page I have a
formuls as
=IF(C14="","",HLOOKUP(C14,Type,2)), it is not coming up
properly, why?

Thnx
Prakash.....
.