Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HLOOKUP Question
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..... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HLOOKUP Question
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..... . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hlookup-row_index_num question | Excel Worksheet Functions | |||
HLOOKUP question | Excel Worksheet Functions | |||
VLOOKUP/HLOOKUP Question | Excel Discussion (Misc queries) | |||
HLOOKUP Question | Excel Programming | |||
HLookup function question | Excel Programming |