Assigning a value to a name
 

Using Excel, is there a way to assign a value (such as salary) to text (such
as employee name)?
--
XCharliX

Hi
try using vLOOKUP based on a lookup table:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Charli" schrieb im Newsbeitrag
...
Using Excel, is there a way to assign a value (such as salary) to
text (such
as employee name)?
--
XCharliX

Insert, Name, Define. Name it charlie and in the 'refers to' section
input =30,000 or whatever number you choose.


--
Scott1523
------------------------------------------------------------------------
Scott1523's Profile: http://www.excelforum.com/member.php...fo&userid=6298
View this thread: http://www.excelforum.com/showthread...hreadid=320180