ComboBox linkedcell population not recognized by Vlookup

E

Ed

I have created a worsheet in which I have Vlookup
formulas performing calculations. I then created Combobox
drop lists and linked given cells. Everything is working
properly except the combobox populating the linkedcell is
not being recognized by my Vlookup functions.
Has anyone ran into this problem? If so can you tell me
how to fix.
Thanks
Ed
 
F

Frank Kabel

Hi
you're probably searching for a number. If yes it could be that the
value returned from your combo box is stored as 'Text' (though it
represents a number).
If you current VLOOKUP formula looks like
=VLOOKUP(A1,'lookup'!A1:B100,2,0)

change this to
=VLOOKUP(--A1,'lookup'!A1:B100,2,0)
Add a double minus in front of the search value
 
Top