Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning a Hyperlink to a CommandButton | Excel Discussion (Misc queries) | |||
Assigning a Hyperlink to a Macro | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |