I have a combo box (Supertypes) that contains the values in the top row of the following chart. The Chart's located from CX20 to DD40. I need to copy the values corresponding to the Supertype to a separate column to use as values in a second combo box (Equipment Types).


ALL CONST OTHER REEFER TRCTRS TRLRS TRUCKS
TMTRL 082 KNM030 STR011 GPMST
TMTRC GPMTRC STR010 GMA041
TMTK GMA031 STR009 GMA021
TMST GMA030 STR008 033
TMSB 034 KNM011 032
TMMISC KNM010 031
GMA050 KNM009 030
FUEL GPMTRL 025
ALL GMA015
001 GMA014
GMA013
GMA012
GMA011
017
013
012
011
010
009
008
007









For some reason, I can't do anything wih this data. For example, if TRUCKS is in CB3, and
I use
=HLOOKUP($CB$3,CX20:DD20,2), I'd expect to get GPMST - but I get #REF.

Can you please tell me why, and what I need to do to prevent this?

Thanks,
Jim Berglund

Addendum: If I copy and paste the values into another region, I can do what I want. So... what's going on???


"Jim Berglund" wrote in message news:Bd8ld.205897$nl.56156@pd7tw3no...
I have a combo box (Supertypes) that contains the values in the top row of the following chart. The Chart's located from CX20 to DD40. I need to copy the values corresponding to the Supertype to a separate column to use as values in a second combo box (Equipment Types).


ALL CONST OTHER REEFER TRCTRS TRLRS TRUCKS
TMTRL 082 KNM030 STR011 GPMST
TMTRC GPMTRC STR010 GMA041
TMTK GMA031 STR009 GMA021
TMST GMA030 STR008 033
TMSB 034 KNM011 032
TMMISC KNM010 031
GMA050 KNM009 030
FUEL GPMTRL 025
ALL GMA015
001 GMA014
GMA013
GMA012
GMA011
017
013
012
011
010
009
008
007









For some reason, I can't do anything wih this data. For example, if TRUCKS is in CB3, and
I use
=HLOOKUP($CB$3,CX20:DD20,2), I'd expect to get GPMST - but I get #REF.

Can you please tell me why, and what I need to do to prevent this?

Thanks,
Jim Berglund