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