Combo box or list box

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.

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

"famdamly" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> famdamly
> ------------------------------------------------------------------------
> famdamly's Profile:
> http://www.excelforum.com/member.php...o&userid=29382
> View this thread: http://www.excelforum.com/showthread...hreadid=500004
>

(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)
--
Max, Singapore GMT+8, xl97
Samples archive at: http://savefile.com/projects/236895
xdemechanik
--
"famdamly" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> famdamly
> ------------------------------------------------------------------------
> famdamly's Profile:
http://www.excelforum.com/member.php...o&userid=29382
> View this thread: http://www.excelforum.com/showthread...hreadid=500004
>