Excel - Combo Box problem

A

ajw150

Is it possible to manipulate what the numerical value of the Cell Lin
will be.

i.e If there is a list of A,B,C,D,E,F and the user clicks C, how ca
you get C to equal say 10., rather than whatever order they are in.

Thanks

Andre
 
J

Jason Morin

Not sure I follow. If the user clicks a letter from the
combo box, the linked cell will be populated with that
letter. You can, in another cell, convert this letter to
some numerical value based on a pre-determined list. So if
A1 is the linked cell, something like this would work:

=VLOOKUP(A1,{"A",4;"C",10;"B",7},2,0)

HTH
Jason
Atlanta, GA
 
Top