Excel: I want to assign numeric values to letters in a speradsheet

  • Thread starter Thread starter Marion Black
  • Start date Start date
M

Marion Black

Hi,
Any help would be very greatfully received!
I am trying to work on a spreadsheet for a staffing rota. Each shift type
has a letter (i.e. E or LS). I need to assign a numeric value to each letter
that represents the number of hours of that shift (i.e. E= 5.5), so that
totals can be calculated more easily...
But I'm stumped! :s
 
With a letter in A1:
=LOOKUP(A1,{"A","B","C"},{1,2,3})
will give the numerical equivalent.

modify to suit.
 
=VLOOKUP(E1,{"E",4;"F",3;"LG",5;"LS",5.5;"MA",4},2,FALSE)

adjust the values to suit

You can put the values in a table and refer to that

=VLOOKUP(E1,Sheet2!A1:B52,FALSE)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
This doesn't seem to keep the letters displayed.
The idea is that the representative letters are displayed (E, LS etc) but
are interpreted by Excel as values, which can then be summed etc.
And pretty please can any replies be put as simply as possible, I'm not fab
with excel :(
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i program alphabet letters to represent numerical values? 4
Giving letters a numerical value, then adding the total. 17
Assigning letter for numerical value 8
Staff rota, how can I make a letter represent a shift? 3
How do I assign a numeric value to a letter 1
Assign text to numeric value 5
Assign Numeric Value to Text 7
How to add up letters to equal a number value. 1

Back
Top