(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