Using Excel, is there a way to assign a value (such as salary) to text (such as employee name)?
C Charli Nov 24, 2004 #1 Using Excel, is there a way to assign a value (such as salary) to text (such as employee name)?
F Frank Kabel Nov 24, 2004 #2 Hi try using vLOOKUP based on a lookup table: http://www.contextures.com/xlFunctions02.html
S Scott1523 Nov 24, 2004 #3 Insert, Name, Define. Name it charlie and in the 'refers to' sectio input =30,000 or whatever number you choose
Insert, Name, Define. Name it charlie and in the 'refers to' sectio input =30,000 or whatever number you choose
