text=number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to type text in one cell which will automatically create a set number in another cell. Such AS

Random 30
ExpCrt 15
HELOC 15
Image 45
The numbers constitute minutes and I can determine how many minutes of work I assign each day
 
Hi
first create a lookup table with these assigned values (lets say on a
separate sheet called 'lookup' wirh column A as the text value and
column B as the associated number).
Now use the following formula (if you enter your text in column A on a
seaparate sheet)
=VLOOKUP(A1,'lookup'!$A$1:$B$100,2,0)
 
Back
Top