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

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" wrote in
message ...

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" wrote in
message ...

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