HLOOKUP Question

[Prakash]

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.....

 

[Tim U]

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