Combo box or list box

[famdamly]

I can't figure out why the linked cell only returns a # value of the
selected cell in the range. I just wanted it to return the actual text
of the selection. I would think this would be the default, but I know
nothing.

Please help this is really frustrating.

 

[Biff]

Hi!

Well, that's how they work! You can use a Match or Lookup formula to get the
actual value

Maybe a data validation drop down list is better suited to what you need.
Look in HELP under DATA VALIDATION LIST. Need more details to make any
further suggestions.

Biff

 

[Max]

(Presuming your earlier post, with response by RD is related to this one)

Assuming you're using a combo box from the Forms Toolbar,
with the settings:

Input range: $B$1:$B$3
Cell link: $A$1 (linked cell pointing to A1)

where

B1=red
B2=white
B3=blue

Put in C1: =INDEX($B$1:$B$3,A1)
(just a slight mod of the formula suggested by RD in your earlier post)

C1 will return "directly" the selection made from the combo box's droplist
Eg: select "white" from the droplist, and "white" will appear in C1

(We could hide away cols A & B for a neater look, of course)