VLOOKUP and COMBO_BOX interface

[Dan]

I'm attempting to force the end user to select from a list
of values in a COMBO_BOX. The value from the COMBO_BOX is
then used in an HLOOKUP on a different tab.

Is there a way in which I can force the HLOOKUP to
recognize the value from the COMBO_BOX? I continue to get
the #N/A error.

Dan

 

[Bob Phillips]

Link the combobox to a cell, and then use that cell in the HLOOKUP.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

I tried that and was unsuccessful.

Thanks though.

 

[Guest]

I figured it out. There must be a math function within
cell refering to cell with COMBO_BOX (ie +0+, *1).