VLOOKUP and COMBO_BOX interface

  • Thread starter Thread starter Dan
  • Start date Start date
D

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
 
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)
 
I figured it out. There must be a math function within
cell refering to cell with COMBO_BOX (ie +0+, *1).
 
Back
Top